title: Which Oracle view contains all constraints together?
body: <p>I'm trying to get CONSTRAINTS from user_objects table like this:</p>
  
  <pre><code> select CASE object_type
        WHEN 'DATABASE LINK' then 'dblinks'
        WHEN 'FUNCTION' then 'functions'
        WHEN 'INDEX' then 'indexes'
        WHEN 'PACKAGE' then 'packages'
        WHEN 'PROCEDURE' then 'procedures'
        WHEN 'SEQUENCE' then 'sequences'
        WHEN 'TABLE' then 'tables'
        WHEN 'TRIGGER' then 'triggers'
        WHEN 'VIEW' then 'views'
        WHEN 'SYNONYM' then 'synonyms'
        WHEN 'GRANT' then 'grants'
        WHEN 'CONSTRAINT' then 'constraints'
        ELSE object_type
        END||'|'||
        CASE object_type
        WHEN 'DATABASE LINK' then 'DB_LINK'
        ELSE object_type
        END||'|'||object_name
  from user_objects
  where object_name not like 'BIN$%'
  and object_type not like '%PARTITION'
  and object_type not in ('PACKAGE BODY')
  order by object_type
  ; 
  
  select distinct object_type
  from user_objects
  ; 
  </code></pre>
  
  <p>But..... USER_OBJECTS has only these types FUNCTION<br>
  INDEX, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, TABLE, TRIGGER, VIEW because select distinct object_type from user_objects; returned them. So this query is not giving my the constraints at all.</p>
  
  <p>Is there a way to get all constraints from Oracle? Which Oracle view should I use?</p>