Oracle查询表字段信息及注释

查询表字段信息：

SELECT * FROM all_tab_columns WHERE OWNER = 'OWNER_NAME' AND TABLE_NAME='TABLE_NAME'
-- 或者
SELECT * FROM user_tab_columns WHERE TABLE_NAME='TABLE_NAME'

查询表字段注释信息：

SELECT * FROM all_col_comments WHERE TABLE_NAME='TABLE_NAME'
--或者
SELECT * FROM user_col_comments WHERE TABLE_NAME='TABLE_NAME'