Oracle查询用户表名+列名+注释

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