Ver constraints de una tabla

SELECT owner, constraint_name,table_name,
       decode(constraint_type,
              'C','CHECK',
              'P','PK',
              'R','FK',
              'U','UK')Tipo,
       index_owner,index_name, r_owner, r_constraint_name,
       status, last_change
FROM dba_constraints
WHERE table_name='NOMBRE_DE_LA_TABLA';