Oracle查询表和字段

查看表字段、类型、注释

SELECT A.COLUMN_NAME,B.comments,A.DATA_TYPE
FROM   USER_TAB_COLUMNS A
LEFT JOIN user_col_comments B ON A.TABLE_NAME=B.table_name AND A.COLUMN_NAME=B.column_name
WHERE  A.TABLE_NAME = '表名'
ORDER  BY A.COLUMN_ID;

获取表字段

select * 
from user_tab_columns 
where Table_Name='用户表' 
order by column_name

获取表注释

select * 
from user_tab_comments 
where Table_Name='用户表'

获取表字段注释

select * 
from user_col_comments 
where Table_Name='用户表'
order by column_name；