Dbeaver工具，导出oracle 表注释、字段注释

--表注释
SELECT table_name,comments,'comment on table '||table_name||' is '''||comments||''';' FROM all_tab_comments WHERE owner = '用户名'
AND table_name IN('表名') ORDER BY table_name;

--字段注释
select 'comment on column '||table_name||'.'||column_name||' is '''||comments||''';' from all_col_comments where owner='用户名' 
AND table_name IN('表名') ORDER BY table_name;