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 in SQLPlus

ORA-00923 in SQLPlus

From: Edwin Hartog <hartoge_at_logica.com>
Date: 2000/07/21
Message-ID: <39783f4c.16993202@news.logica.com>#1/1

Help.

What makes the following statements in SQLPlus fail ?? If you have any tips, please reply !!!!

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

Thanks 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