如何将列中的low_value和high_value转换为实际的值

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28878983/viewspace-2137705/