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

set feedback off

to create such a flat file do:

set newpage 0
set space 0
set echo off
set feedback off
set head off
set pagesize 0
set linesize 104

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
Received on Fri Mar 23 2001 - 02:27:52 CST