Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Index Expression
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
![]() |
![]() |