如何將列中的low_value和high_value轉換為實際的值

xypincle發表於2017-04-20
1.
select low_value,high_value from dba_tab_col_statistics where owner='SYS' and table_name='T1' and column_name='OBJECT_ID';
LOW_VALUE                                            HIGH_VALUE
--------------------------------------------------    --------------------------------------------------
C103                                                        C3096333

2.
SQL>var lowvalue number;
SQL>var highvalue number;

SQL>exec dbms_stats.convert_raw_value('C103',:lowvalue);
SQL>print :lowvalue;
LOWVALUE
----------
  2

SQL> exec dbms_stats.convert_raw_value('C3096333',:highvalue);
HIGHVALUE
----------
     89850

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28878983/viewspace-2137705/，如需轉載，請註明出處，否則將追究法律責任。

相關文章