title: Getting unique constraint column names from oracle database
body: <p>I am implementing a search functionality from UI for this I want to give a drop down of column names which have unique constraints along with any primary key column if present, so user can search with any of these selected column relate data. I have searched for such query but haven't found</p>
  
  <p>Something like: </p>
  
  <pre><code>SELECT COLUMN_NAMEs FROM TABLE WHERE CONSTRAINTS UNIQUE OR PRIMARY
  </code></pre>
  
  <p>Is there any query to achieve this ... </p>