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 -> Re: ORA-00923 in SQLPlus

Re: ORA-00923 in SQLPlus

From: Conan Farrell <conan_at_>
Date: 2000/07/24
Message-ID: <zKSe5.9797$r4.5078@news.indigo.ie>#1/1

Delete the spaces between the '''' and then statement will work

HTH
Conan

Edwin Hartog wrote in message <39783f4c.16993202_at_news.logica.com>...
>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 Mon Jul 24 2000 - 00:00:00 CDT

Original text of this message

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