Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> ORA-00923 error in SQLPLUS
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;
*
Thank in advance,
Edwin Hartog (hartoge_at_logica.com) Received on Fri Jul 21 2000 - 00:00:00 CDT
![]() |
![]() |