Home » SQL & PL/SQL » SQL & PL/SQL » View query
View query [message #264643] Tue, 04 September 2007 01:54 Go to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Hi,

Is there any data dictionary table from which I would be able to access the names of all columns in a view?

Please respond asap.
Re: View query [message #264644 is a reply to message #264643] Tue, 04 September 2007 01:58 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
USER_TAB_COLUMNS
Re: View query [message #264645 is a reply to message #264644] Tue, 04 September 2007 02:00 Go to previous messageGo to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
I need them for a view. In user_tab_columns and all_tab_columns you can see tables and related information only.
Re: View query [message #264647 is a reply to message #264645] Tue, 04 September 2007 02:03 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
hedonist123 wrote on Tue, 04 September 2007 09:00
I need them for a view. In user_tab_columns and all_tab_columns you can see tables and related information only.

Oracle disagrees (highlight is mine):
OracleŽ Database Reference10g Release 2 (10.2)
USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user.

MHE
Previous Topic: PL/SQL code of HMAC-MD5 algorithm
Next Topic: regarding dates
Goto Forum:
  


Current Time: Sat Dec 10 18:59:24 CST 2016

Total time taken to generate the page: 0.08130 seconds