Getting Index Expression

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. Received on Mon Mar 01 1999 - 08:20:45 CST