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'