oracle查询表信息

–查询某张表的字段信息

SELECT *  FROM all_tab_cols WHERE table_name = 'ASSESSMENT_CREDIT' and owner='DRAN';

–查某张表的主键字段

select * from user_cons_columns cc
join user_constraints uc on uc.constraint_name=cc.constraint_name
where cc.table_name = 'ASSESSMENT_CREDIT' and cc.owner='DRAN'
and constraint_type ='P';