select 'comment on TABLE '||table_name||' is '''||comments||''';' from user_tab_comments
select table_name,comments from user_tab_comments ; 这个更直观些
select table_name,column_name,comments from user_col_comments; 这个是各个表中具体列的
select a.table_name,a.comments tb_comments,b.column_name,b.comments col_comments from user_tab_comments a,user_col_comments b where a.table_name=b.table_name
select 'comment on TABLE '||table_name||' is '''||comments||''';' from user_tab_comments
from user_tab_comments
from user_tab_comments ;
这个更直观些
from user_col_comments;
这个是各个表中具体列的
select a.table_name,a.comments tb_comments,b.column_name,b.comments col_comments
from user_tab_comments a,user_col_comments b
where a.table_name=b.table_name
select 'comment on TABLE '||table_name||' is '''||comments||''';'
from user_tab_comments