select index oracle : Sql Query to Extract the Index informations for the Table in Oracle apps

select index oracle : Sql Query to Extract the Index information's for the Table in Oracle apps

 

In this post , I will share the SQL query which helps to extract the index information's from Oracle Database. With the help of this select index oracle  , we can easily find the indexes for the tables in oracle apps. Here below is the example of the select index oracle sql query.

 

 

select index_name from dba_indexes where table_name='tablename';

 

Just enter the table name and it will show you the list of the dba_indexes for the table.