oracle 根据表名找字段与注释

 -- oracle 根据表名找字段与注释
select bb.TABLE_NAME,bb.COLUMN_NAME ,aa.COLUMN_ID,  aa.DATA_TYPE,aa.DATA_LENGTH ,bb.COMMENTS 
from user_tab_cols aa 
join user_col_comments bb on aa.TABLE_NAME = bb.TABLE_NAME and aa.COLUMN_NAME = bb.COLUMN_NAME 
join  dba_objects cc on bb.TABLE_NAME = cc.Object_Name
where cc.created > to_date('2019-05-21','YYYY-MM-DD')
order by cc.created desc , bb.TABLE_NAME,aa.COLUMN_ID  ;