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

From: Nick P <nick_pope_at_hotmail.com>
Date: Mon, 19 Mar 2001 12:26:03 -0000
Message-ID: <tbbun5i09fule9@xo.supernews.co.uk>

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" <dino1_at_ms1.hinet.net> wrote in message news:oqlbbtguj73ietr9mcdirlg9kckj4jcfcc_at_4ax.com...
> 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
Received on Mon Mar 19 2001 - 06:26:03 CST