select 'COMMENT ON COLUMN 表名.' || a.COLUMN_NAME ||
' IS ''' || b.comments || ''';'
from user_tab_columns a, user_col_comments b
where a.table_name = b.table_name
and a.COLUMN_NAME = b.column_name
and a.table_name = '源表名';
相同结构表复制注释
最新推荐文章于 2022-03-29 14:44:23 发布