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

Oracle LazyDBA home page