-- 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 ;