Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting column names for indexes
SELECT * FROM ALL_IND_COLUMNS
WHERE INDEX_NAME = 'ADDR_IDX0'
ORDER BY COLUMN_POSITION;
"Shirish Nilekar" <shirish_at_shaydes.com> wrote in message
news:af54e0f8.0207300812.50ec1dd4_at_posting.google.com...
> Hi,
>
> I want to get the column info. for a particular
> index. Here's my scenario:
>
> There is a table, say address, with a unique
> index addr_idx0 on (zip, st#, apt#). I would
> like to know a query which returns me the
> columns in addr_idx0.
>
> Thanks.
>
> --shirish
> (http://www.shaydes.com)
Received on Tue Jul 30 2002 - 11:24:44 CDT