Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Output in SQL Plus
On Mon, 8 Jul 2002 15:46:58 +0100, "Faria Adl"
<Farian.Adl_at_ORGAPLAN.de> wrote:
>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
>
ACCEPT is a sql*plus command. Sql*plus commands should NOT be
terminated by a /
As your sql buffer didn't change
this snippet
>ACCEPT inp PROMPT 'Input something? (Y/N)'
>/
is just functioning properly
and
>ACCEPT inp PROMPT 'Input something? (Y/N)'
on it's own should do the trick.
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Mon Jul 08 2002 - 12:49:02 CDT
![]() |
![]() |