ORACLE 查看表和表字段注释

– 获取指定表名的字段注释
select * from user_col_comments t where t.table_name = ‘ADDRESS’；
– 获取所有表的字段注释
select * from user_col_comments ;
– 获取所有表的注释
select * from user_tab_comments;
–获取指定表的注释
select * from user_tab_comments t where t.table_name = ‘ADDRESS’;