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

From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Sun, 25 Mar 2001 07:50:00 +0200
Message-ID: <3ABD8708.F21BF80F@intersystemsww.com>

Dino Hsu 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

Hi Dino,
You can find how to do this in the
SQL*Plus User's Guide and Reference which is available from here...

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a82950/toc.htm

Basically, to turn "feedback" off, type the following once you've started up an SQL*Plus session:

set feedback off

Good Luck,
Avi. Received on Sat Mar 24 2001 - 23:50:00 CST