Excellent!
That's exactly what I needed.

Thanks,
Charles.

-----Original Message-----
From: Burns Melanie E
[mailto:oracledba-ezmlmshield-x96328636.[Email address protected]
Sent: February 27, 2006 2:33 PM
To: LazyDBA Discussion
Subject: RE: INDEX Columns



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



--------
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




--------
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