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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to suppress the total line in SQL Plus?

Re: How to suppress the total line in SQL Plus?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 19 Mar 2001 18:23:47 +0100
Message-ID: <l3gcbtgu6jrkh2c5if340nd52rt2lnk0jj@4ax.com>

On Mon, 19 Mar 2001 17:59:17 +0800, Dino Hsu <dino1_at_ms1.hinet.net> wrote:

>Dear all,
>
>When a SELECT SQL is executed, a total line will be shown at the end
>of the report, such as:
>12 rows selected. or
>no rows selected.
>
>The cases are that I want to create an interface file and I don't need
>any descriptive or decorative wordings. How can we suppress this total
>line? Thanks in advance.
>
>Regards,
>Dino

set feedback off

Please at least *try* to consult the sql*plus manuals for such easy questions.

Regards,

Sybrand Bakker, Oracle DBA Received on Mon Mar 19 2001 - 11:23:47 CST

Original text of this message

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