I need to know how to find what column an index is against . I used the following query to determine how many indexs are on the table.
SQL> select * from user_indexes where index_name like 'CARDHLDR_CONTACT%';
But , the result doesnt identify the column indexed.
Any ideas?
SQL> select * from user_indexes where index_name like 'CARDHLDR_CONTACT%';
But , the result doesnt identify the column indexed.
Any ideas?