ORACLE取字段中的注释

select * from (
SELECT ‘comment on column ‘|| t.table_name||’.’||
t.colUMN_NAME||’ is ‘|| ””||
t1.COMMENTS ||”’ ‘||’;’ as commom
FROM User_Tab_Cols t, User_Col_Comments t1
WHERE t.table_name = t1.table_name
AND t.column_name = t1.column_name(+) and t1.COMMENTS is not null) t
where t.commom like ‘%GR_ZJZIGE.%’

将GR_ZJZIGE换成表名就可以了。