title: How to see a list of all the indexes (including implicit ones) in SQL*Plus?
body: <p>Is there some way to get a list of all the indexes on a particular table using SQL*Plus?</p>
  
  <p>I created a table</p>
  
  <pre><code>CREATE TABLE temp(
  id NUMBER PRIMARY KEY,
  name VARCHAR2(20));
  </code></pre>
  
  <p>There should be an implicit index created on the primary key (<code>id</code>). How can I see that index?</p>
  
  <pre><code>SELECT * FROM all_indexes WHERE table_name = 'temp';
  </code></pre>
  
  <p>gives</p>
  
  <blockquote>
    <p>no rows selected</p>
  </blockquote>