Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> ORA-00923 error in SQLPLUS

ORA-00923 error in SQLPLUS

From: Edwin Hartog <hartoge_at_logica.com>
Date: 2000/07/21
Message-ID: <39780b93.3749930@news.logica.com>#1/1

Help,

I downloaded a backup script and run it in SQLPlus, the last lines gave an ORA-00923 error: FROM keyword not found where expected

What is wrong in the lines below and why does it fail ??

select 'echo '||' ' ' ' ||'BACKUPS are now COMPLETE !'||' ' ' ' from dual;
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

select 'echo '||' ' ' ' ||'Your RESTORE script is located at '||'/bckup/rdbms'||'/coldrest.lst !'|| ' ' ' ' from dual;

                    *

ERROR at line 1:
ORA-00923: FROM keyword not found where expected

Thank in advance,

Edwin Hartog (hartoge_at_logica.com) Received on Fri Jul 21 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US