title: How to show indexes in Oracle SQL
body: <p>I have created an index in Oracle SQl-</p>
  
  <blockquote>
    <p>create index ind_cname on country(capital)</p>
  </blockquote>
  
  <p>When executed I got a success message.Now I want to see the created Index.
  Please help in the syntax to show index.</p>
  
  <p>I am new to Oracle .I want a query which shows indexes for the table.</p>
  
  <p>Thanks</p>