Re: ORA-00923 in SQLPlus

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