oracle 数据库注释导出,Oracle 数据库注释导出/导入

select c.a from (

select 'comment on column '|| atC.TABLE_NAME || '.' || ATC.COLUMN_NAME || ' is ' || '#@#' || ucc.comments || '#@#' || ';' a

from

(select ATC.OWNER,

atC.TABLE_NAME,

ATC.COLUMN_NAME,

ATC.DATA_TYPE,

ATC.DATA_LENGTH,

ATC.NULLABLE

from all_tab_columns ATC

where ATC.owner ='USER' ) atc

left outer join all_col_comments ucc

on atc.table_name=ucc.table_name and

atc.column_name=ucc.column_name

left outer join all_tab_comments utc

on atc.table_name=utc.table_name

where ucc.comments is not null

order by atc.table_name,atc.column_name) c

group by c.a

having c.a not like '%??%'

执行以上sql即可生成可执行sql ,以上sql复制后执行时可能会遇到问题

中英文标点问题  ： 将sql中的引号'全部替换一遍，替换成英文引号