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?
When using oacle i have found that I have to set linesize and pagesize = 1000 everytime I open an oracle session , or the output is scrambled...
Is there a way to overcome this annoying feature in oracle , ie , set some sort of default etc etc.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.