Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Output in SQL Plus
Hope I didn't overlook obvious solution...
After ACCEPT... comes again result of first select, how to avoid this?
Thanks
Farian
set echo off
set heading off
set verify off
set feedback off
set serveroutput on
spool D.LOG
SELECT '=== Exec of D.SQL ' || TO_CHAR(SYSDATE, 'DD.MM.YYYY') || ' ===' FROM
DUAL
/
ACCEPT inp PROMPT 'Input something? (Y/N)'
/
prompt === End of Script D.SQL===
SPOOL OFF Received on Mon Jul 08 2002 - 09:46:58 CDT
![]() |
![]() |