Oracle PL/SQL Tutorial/System Tables Data Dictionary/user indextypes
Query user_indextypes
<source lang="sql">
SQL> SQL> select indextype_name, implementation_name
2 from user_indextypes;
no rows selected</source>
<source lang="sql">
SQL> SQL> select indextype_name, implementation_name
2 from user_indextypes;
no rows selected</source>