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: how do I find out column name on which a index is build

Re: how do I find out column name on which a index is build

From: deana strbevski <deana.strbevski_at_ina.hr>
Date: Wed, 10 Jan 2001 08:26:31 +0100
Message-ID: <3A5C0EA7.5E686022@ina.hr> 






there is a user_ind_columns view



select * from user_ind_columns where index_name = 'INDEXNAME';



shdu_at_my-deja.com wrote:



> how do I find out column name on which a index is build

> Thanks

>

> SF

>

> Sent via Deja.com

> http://www.deja.com/

Received on Wed Jan 10 2001 - 01:26:31 CST












Original text of this message













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