Or use :

select table_name, column_name, column_position
from dba_ind_columns
where table_name = 'TABLE_NAME';



-----Original Message-----
From: Sikora Thomas [mailto:oracledba-ezmlmshield-x51913145.[Email address protected]
Sent: Monday, February 27, 2006 1:27 PM
To: LazyDBA Discussion
Subject: RE: INDEX Columns

Hi,

Select * from dba_tab_columns;

...will find DDL detail.

tom
Pittsburgh

-----Original Message-----
From: Champagne Charles
[mailto:oracledba-ezmlmshield-x25517183.[Email address protected]
Sent: Monday, February 27, 2006 14:18
To: LazyDBA Discussion
Subject: INDEX Columns


Good day.
How do you extract the "Table columns" from an index using a SQL command?

Thanks,
Charles Champagne
613-948-5505 | facsimile / télécopieur 613-948-5298 | TTY/ATS 1-800-665-0354 Charles.[Email address protected] CAS BASIS - DBA | Enterprise Resource Planning Solutions | ITB BASIS SAE - ABD | Division de la planification des ressources de l'entreprise | DGI Canada Revenue Agency | 2465 St-Laurent Blvd, Ottawa Ontario K1A 0L5 Agence du revenu du Canada | 2465 boul. St-Laurent, Ottawa Ontario K1A 0L5 Government of Canada | Gouvernement du Canada




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page