Oracle查看主键名、状态

select table_name,constraint_name,constraint_type,status 
from user_constraints 
where constraint_type='P' and table_name='大写表名';