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 -> Re: Output in SQL Plus

Re: Output in SQL Plus

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 08 Jul 2002 19:49:02 +0200
Message-ID: <o0kjius5kcd82bc1c4gav879qq9b94h1dj@4ax.com>


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

Original text of this message

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