Oracle comment乱码

来自ling
跳转至: 导航搜索
select 'COMMENT ON COLUMN '||t.table_name||'.'||t.column_name||' IS ' || '''' ||t.comments||''';'
from user_col_comments t 
where t.table_name not like 'BIN%'
and length( t.comments)>0;