List indexes and indexed columns with a SELECT in Oracle

This simple SELECT will list indexes and indexed columns in Oracle.

SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME

FROM ALL_IND_COLUMNS A

WHERE INDEX_OWNER = 'SYSADM'

AND   TABLE_NAME LIKE 'PS_CHARTFIELD%'

ORDER BY INDEX_OWNER, TABLE_NAME, INDEX_NAME, COLUMN_POSITION, COLUMN_NAME