Export oracle comments and oracle comments

Export oracle comments and oracle comments

Indicates that a user has a comment + Table comment + field details + field comment

select  ATC.OWNER,        atC.TABLE_NAME,        utc.comments,        ATC.COLUMN_NAME,        ATC.DATA_TYPE,        ATC.DATA_LENGTH,        ATC.NULLABLE,        ucc.commentsfrom    (select ATC.OWNER,            atC.TABLE_NAME,            ATC.COLUMN_NAME,            ATC.DATA_TYPE,            ATC.DATA_LENGTH,            ATC.NULLABLE     from all_tab_columns ATC     where ATC.owner in ('UserName') ) atcleft outer join user_col_comments ucc             on atc.table_name=ucc.table_name and                 atc.column_name=ucc.column_nameleft outer join user_tab_comments utc             on atc.table_name=utc.table_nameorder by atc.table_name,atc.column_name

 

For multiple users, the metric + Table attention + field attention

select  ATC.OWNER,        atC.TABLE_NAME,        ATC.COLUMN_NAME,        utc.comments,        ATC.DATA_TYPE,        ATC.DATA_LENGTH,        ATC.NULLABLE,        ucc.commentsfrom    (select ATC.OWNER,            atC.TABLE_NAME,            ATC.COLUMN_NAME,            ATC.DATA_TYPE,            ATC.DATA_LENGTH,            ATC.NULLABLE     from all_tab_columns ATC     where ATC.owner in ('UserName1','UserName2') ) atcleft outer join all_col_comments ucc             on atc.table_name=ucc.table_name and                 atc.column_name=ucc.column_nameleft outer join all_tab_comments utc             on atc.table_name=utc.table_nameorder by atc.table_name,atc.column_name