| displaytables [message #52427] |
Sat, 20 July 2002 09:28  |
Jeff
Messages: 63
Registered: July 1999
|
Member |
|
|
I am using the following SQL statement to display the files in my database: (select filename from dba_data_files) but I get an error invalid column name. What is the correct SQL for this?
Thanks
|
|
|
|
| Re: displaytables [message #52431 is a reply to message #52427] |
Sun, 21 July 2002 11:23  |
Alan
Messages: 68
Registered: October 1999
|
Member |
|
|
Check the table structure for "dba_data_files"
SQL> desc dba_data_files
You've got a mistake. (THE UNDERSCORE)
it should be
SQL> select file_name from dba_data_files;
Becareful next time
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
