Oracle DB list table indexes and their columns for specific table

list-table-indexes-on-oracledb.sql

select index_name, column_name from user_ind_columns where table_name='&tablename';
-- Enter table name after running this query

-- dba_ind_columns : This is to used if login with user having DBA role
-- all_ind_columns : This is to used if login with user having normal role
-- user_ind_columns : This is to used if login with user having normal role

-- OK nvm, this one is better;

set pagesize 50000 verify off echo off

col table_name head 'Table Name' format a30
col index_name head 'Index Name' format a30
col column_name head 'Column Name' format a30

break on table_name on index_name

select    table_name, index_name, column_name
from    all_ind_columns
where    table_name like upper('&Table_Name')
order by table_name, index_name, column_position
/

https://techgoeasy.com/find-indexes-and-assigned-columns-for-oracle-table/