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 Index Expression

Re: Getting Index Expression

From: DelphiDev <DelphiDev_at_yahoo.com>
Date: Mon, 01 Mar 1999 14:30:30 -0500
Message-ID: <36DAEAD5.415C6FE4@yahoo.com>


Ms. Harvey, thanks, this is exactly what I am looking for.

Ms. D.H. Harvey wrote:

> DelphiDev (DelphiDev_at_yahoo.com) wrote:
> : Is there a way to retrieve the fields used in an index? I would think
> : that this would be a field in the user_indexes table; it lists out the
> : table that it is associated with (table_name), and a lot of other
> : information.
>
> : For instance:
> : CREATE INDEX LNAME ON PERSONEL(LNAME,FNAME);
>
> : I want to be able to retrieve the "LNAME,FNAME" expression down the
> : road.
>
> : Thanks.
>
> user_ind_columns
Received on Mon Mar 01 1999 - 13:30:30 CST

Original text of this message

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