SQL> select table_name,column_name,num_distinct,num_buckets,histogram from dba_tab_col_statistics where owner='MTS' and table_name='RECORD1';
TABLE_NAME COLUMN_NAME NUM_DISTINCT NUM_BUCKETS HISTOGRAM
------------------------------ ------------------------------ ------------ ----------- ---------------
RECORD1 ID 419313 1 NONE
RECORD1 ENTERPRISE_ID 741 254 HEIGHT BALANCED
RECORD1 OPERATOR_ID 7629 1 NONE
RECORD1 TEMPLATE_ID 1148 1 NONE
RECORD1 WORK_CODE 608 1 NONE
RECORD1 NAME 121552 1 NONE
RECORD1 CREATE_TIME 411904 1 NONE
RECORD1 ACTUAL_LONGITUDE 146240 1 NONE
RECORD1 ACTUAL_LATITUDE 145056 1 NONE
RECORD1 ACTUAL_LOCDESC 41248 1 NONE
RECORD1 CONTENT 50040 1 NONE
RECORD1 DELETE_STATE 2 1 NONE
RECORD1 CITY_NAME 3 1 NONE
RECORD1 COUNTY_NAME 3 1 NONE
RECORD1 PROVINCE_NAME 3 1 NONE
RECORD1 PIC_NUM 8 1 NONE
16 rows selected