Oracle query Table Comments and column comments

Oracle query Table Comments and column comments

[SQL] 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 t3 where 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'

 

Result: 221230