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

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

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 Mon Mar 19 2001 - 07:42:13 CST