ORA-00900: invalid SQL statement

SQL> select  file# ||’ to ‘|| name from v$dbfile;

select  file# ||’ to ‘|| name from v$dbfile
*
ERROR at line 1:
ORA-00900: invalid SQL statement

When you try to concatenate a field name with “#”, it could result in above error message. Use a different dictionary view, in this case you could use dba_data_files.

Example:-

select file_id ||’ to ‘|| FILE_NAME from dba_data_files ;

Leave a Reply

100 Arbor Oak Drive, #200
Ashland, Virginia 23005-2261
Phone: 1-(804)-368-8631
Toll Free: 1-(877)-230-7449
Website: http://www.ooacllc.com
Email: info@ooacllc.com