ORACLE 查看表与字段注释

最新推荐文章于 2024-03-27 02:07:09 发布

原创最新推荐文章于 2024-03-27 02:07:09 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

6 篇文章

订阅专栏

select  ATC.OWNER,atC.TABLE_NAME,utc.comments,ATC.COLUMN_NAME, ucc.comments,ATC.DATA_TYPE,ATC.DATA_LENGTH,ATC.NULLABLE from

(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 ('DBJHQ')  AND ATC.TABLE_NAME='T_GHDW_DZ' ) atc

left outer join user_col_comments ucc on atc.table_name=ucc.table_name and atc.column_name=ucc.column_name

left outer join user_tab_comments utc on atc.table_name=utc.table_name 

order by atc.table_name,atc.column_name