How to suppress the total line in SQL Plus?

[Dino Hsu]

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

[Nick P]

It is one of the following...

set echo off

set feedback off

set verify off

set termout off

set showmode off

It is a few months since I wrote a SQL*Plus report, but all my old reports
have a whole load of these SET commands at the top. I would put my money on
FEEDBACK being switched off. It is one of those things that I can never
quite remember which one does it!!!! The manual might help, these are all
online now on www.oracle.com.

Nick

"Dino Hsu" <di...@ms1.hinet.net> wrote in message
news:oqlbbtguj73ietr9m...@4ax.com...

[Steve Bell]

Hi,
If you're asking how to turn off the "X rows selected" message in
SQL*Plus, just type (or include in your script)

SET FEEDBACK OFF

Hope this helps,
Steve

[Andreas Necker]

hi,

SET FEEDBACK OFF

--
Andreas Necker

ISB AG Tel: +49 (0)721/82800-0
Karlstrasse 52-54 Fax: +49 (0)721/82800-82
76133 Karlsruhe mailto:Andreas...@isb-ka.de
Germany http://www.isb-ka.de

[Sybrand Bakker]

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

set feedback off

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

Regards,

Sybrand Bakker, Oracle DBA

[Juan Miranda]

SET FEEDBACK OFF

Dino Hsu <di...@ms1.hinet.net> escribió en el mensaje de noticias
oqlbbtguj73ietr9m...@4ax.com...

[Dino Hsu]

Dear all,

The complete answer of a flat file is the combination of Nick and
Chritof:

SET PAGESIZE 0
SET LINESIZE 240
SET FEEDBACK OFF
SET HEAD OFF
SET NEWPAGE 0
SET SPACE 0
SET ECHO OFF
SET VERIFY OFF -- this turn off the macro expansion message
SET TERMOUT OFF
SET SHOWMODE OFF

Thanks for all your help.

Dino