–查询某张表的字段信息
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';