批量生成注释命令:
表:
select 'comment on table '||a.owner||'.'||a.TABLE_NAME||' is '||''''||a.comments||''''||';' from dba_tab_comments a where a.OWNER='JKDA_ZZNEW';
列:
select 'comment on column '||a.owner||'.'||a.table_name||'.'||a.column_name||' is '||''''||a.comments||''''||';' from dba_col_comments a where a.OWNER='JKDA_ZZNEW';