查看当前用户constraint信息

select uc.table_name,ucc.column_name,uc.constraint_name,uc.constraint_type,uc.status
from user_constraints uc 
  inner join user_cons_columns ucc
    on uc.constraint_name=ucc.constraint_name
order by 1;