oracle 查询表的注释，及列的注释

select t3.table_name,t3.comments,t2.comments,t1.COLUMN_NAME       ,t1.DATA_TYPE||'('||decode(t1.DATA_TYPE, '', t1.DATA_PRECISION+t1.DATA_SCALE, t1.data_length)||')'from user_tab_cols t1, user_col_comments t2, user_tab_comments t3where t1.TABLE_NAME=t2.table_name(+)and t1.COLUMN_NAME=t2.column_name(+)and t1.TABLE_NAME=t3.table_name(+)and lower(t1.TABLE_NAME)='user';

select distinct data_length from dba_tab_cols where data_type ='NUMBER'

结果：

22

1

2

3

0