SELECT ‘comment on column ‘|| t.table_name||’.’||t.colUMN_NAME||’ is ’ || ‘’‘’ ||
(CASE WHEN T1.COMMENTS IS NULL THEN (SELECT T2.COMMENTS FROM User_Col_Comments T2 WHERE T1.colUMN_NAME=T2.colUMN_NAME AND T2.COMMENTS IS NOT NULL and rownum=1) ELSE NULL END) ||‘’‘’|| ‘;’
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 null
AND t.table_name in (SELECT table_name FROM User_Col_Comments where table_name like ‘TB%’ and comments is null
)文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-692394.html
文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-692394.html
到了這里，關(guān)于oracle批量導(dǎo)出字段注釋，并且相同字段注釋為空的情況取有數(shù)據(jù)的第一行賦值的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
