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: 25417
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: Wed May 24 16:35:53 CDT 2017

Total time taken to generate the page: 0.20554 seconds