accept usrnm prompt “Enter The User Name -> ”
accept tblnm prompt “Enter The Table Name -> ”
select index_name, substr(column_name,1,15) “Colm Name”, column_position “Position”
from dba_ind_columns
where table_name = upper(‘&tblnm’)
and table_owner = upper(‘&usrid’)
order by index_name, column_position;