公司dba提供的脚本:
set serveroutput onset feedback offspool /tmp/getcomments.outselect 'comment on table ' || table_name || ' is ' || '''' || comments || ''';' from user_tab_comments where comments is not null;select 'comment on column ' || table_name || '.' || column_name || ' is ' || '''' || comments || ''';' from user_col_comments;spool off;
添加表注释:COMMENT ON table t1 IS '个人信息';添加字段注释:comment on column t1.id is 'id';comment on column t1.nameis '姓名';comment on column t1.age is '年龄';