Home » SQL & PL/SQL » SQL & PL/SQL » Oracle: SQL to query all column names on all tables
Oracle: SQL to query all column names on all tables [message #406162] Tue, 02 June 2009 10:46 Go to next message
oranooob
Messages: 86
Registered: May 2009
Member
Hello folks

Howto query all column names on all tables?

thanks
Re: Oracle: SQL to query all column names on all tables [message #406166 is a reply to message #406162] Tue, 02 June 2009 10:57 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
query dba|all|user_tab_columns
Re: Oracle: SQL to query all column names on all tables [message #406167 is a reply to message #406162] Tue, 02 June 2009 10:57 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Please read Forum Guide.
You could have searched before posting.

Check all_tab_columns.

Check the documentation for Data Dictionaries.

By
Vamsi
Previous Topic: update
Next Topic: How to extend data in select table
Goto Forum:
  


Current Time: Sat Dec 10 12:49:26 CST 2016

Total time taken to generate the page: 0.08722 seconds