| View query [message #264643] |
Tue, 04 September 2007 01:54  |
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 #264647 is a reply to message #264645] |
Tue, 04 September 2007 02:03  |
 |
Maaher
Messages: 7065
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
