--如下sql:
select a.table_name,
a.column_name,
a.comments,
'comment on column ' || a.table_name||'.'||a.column_name || ' is ' || '''' || a.comments ||
''';' sql_
from dba_col_comments a
where a.owner = 'oracle用户名'
and a.comments is not null
order by a.table_name
oracle取表结构及其注释的SQL
最新推荐文章于 2022-09-26 15:13:04 发布