Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Output in SQL Plus

Output in SQL Plus

From: Faria Adl <Farian.Adl_at_ORGAPLAN.de>
Date: Mon, 8 Jul 2002 15:46:58 +0100
Message-ID: <agc8fv$49i$1@newsreader2.netcologne.de>


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

Original text of this message

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