Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting column names for indexes

Re: Getting column names for indexes

From: Nigel Puntridge <nigel_puntridge_at_hotmail.com>
Date: Tue, 30 Jul 2002 12:24:44 -0400
Message-ID: <3d46bdce$1_8@news.teranews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US