字段:
select 'comment on column '||table_name||'.'||column_name||' is '''||comments||''';'
from user_col_comments
表:
select 'comment on TABLE '||table_name||' is '''||comments||''';'
from user_tab_comments
select 'comment on column '||table_name||'.'||column_name||' is '''||comments||''';'
from user_col_comments
表:
select 'comment on TABLE '||table_name||' is '''||comments||''';'
from user_tab_comments