user_tab_col_ststistics (low_value,high_value)

 

SQL> select low_value,high_value from user_tab_col_statistics where table_name='T1';

LOW_VALUE  HIGH_VALUE
---------- ----------------------------------------------------------------
C102       C302

SQL> select max(a) from t1;

    MAX(A)
----------
     10000

SQL> select min(a) from t1;

    MIN(A)
----------
         1

SQL> select max(a),min(a) from t1;

    MAX(A)     MIN(A)
---------- ----------
     10000          1

SQL> show user
USER is "XH"

 

 

SQL> select utl_raw.cast_to_number(low_value) low,utl_raw.cast_to_number(high_value) hight from user_tab_col_statistics where table_name='T1';

       LOW      HIGHT
---------- ----------
         1      10000

阅读更多
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭