1: Query used to discover the table indexes. 2: Query used to show table metadata.

Table_Indexes.sql

-- 1: Query used to discover the table indexes.
select 
   table_name, 
   index_name, 
   column_name
from 
   dba_ind_columns
where table_name = &table
order by 
   table_name, 
   column_position;

--

-- 2: Query used to show table metadata.
select * 
from 
  all_all_tables 
where 
  table_name = &table;