作者:放屁虫666_530 | 来源:互联网 | 2023-05-17 07:15
SELECTb.table_name,b.commentsastab_comments,c.COLUMN_NAME,c.commentsascol_commentsFROMuser
SELECT b.table_name,b.comments as tab_comments,c.COLUMN_NAME,c.comments as col_comments
FROM user_tab_columns a
left join user_tab_comments b
on a.table_name=b.table_name
left join user_col_comments c
on a.TABLE_NAME=c.table_name and a.COLUMN_NAME=c.column_name