user_tab_col_ststistics (low_value,high_value)
来源:互联网 发布:mac jenkins root权限 编辑:程序博客网 时间:2024/06/13 08:44
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
- user_tab_col_ststistics (low_value,high_value)
- low_value / high_value
- oracle 查看列统计信息中 low_value
- 在solaris10操作系统下安装Oracle10.2g客户端
- mysql学习之路二(转)
- java线程安全
- 最老程序员创业札记:全文检索、数据挖掘、推荐引擎应用46
- mysql学习之路三(转)
- user_tab_col_ststistics (low_value,high_value)
- mysql学习之路四(转)
- sql自动批量生成海量数据的小工具(安装包) 链接
- mysql学习之路五(转)
- 数组常用排序
- 百度神奇之旅
- centos 上安装pdksh包
- 面试时,怎样“谈薪”?
- js去掉前后空格