ORACLE查询列及列属性，查询主键语句

ORACLE查询列及列属性：

SELECT COLUMN_NAME,DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME = ‘tablename’；

 

查询主键：

select col.column_name

   from user_constraints con,  user_cons_columns col

   where con.constraint_name = col.constraint_name

   and con.constraint_type = 'P'

   and col.table_name = ‘tablename’