SELECT distinct b.column_name 列明,
a.comments 字段注释,
b.data_type 字段类型,
b.data_length 字段长度,
b.TABLE_NAME 表名称
FROM user_col_comments a, all_tab_columns b
WHERE a.table_name = b.table_name
and b.COLUMN_NAME = a.column_name
and a.table_name in ('表名')
order by b.TABLE_NAME
查询表名称和注释
最新推荐文章于 2020-01-13 21:45:34 发布