Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to suppress the total line in SQL Plus?

How to suppress the total line in SQL Plus?

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Thu, 22 Mar 2001 16:05:57 +0800
Message-ID: <2jcjbt887nqpd58vs58o6khfauo6d7cmjk@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 Thu Mar 22 2001 - 02:05:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US