Home » Other » General » need to find how to get row count not to return
need to find how to get row count not to return [message #103158] Fri, 21 February 2003 13:36 Go to next message
Kristy
Messages: 2
Registered: June 2001
Junior Member
When you run a simple select statment, the results return a row count

abcrpt.exe
1 row returned.

I need to be able to turn this off. I am use to writing query's on microsoft sql. We would use set nocount on.

How would I do this on oracle?
Re: need to find how to get row count not to return [message #103180 is a reply to message #103158] Wed, 26 February 2003 07:43 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
quote:
----------------------------------------------------------------------
When you run a simple select statment, the results return a row count
  
abcrpt.exe
1 row returned.
  
I need to be able to turn this off. I am use to writing query's on microsoft sql. We would use set nocount on.
  
How would I do this on oracle?

----------------------------------------------------------------------

[i]SQL> SET FEEDBACK OFF

A
Previous Topic: Do I need Linux to be an Oracle DBA
Next Topic: There was an internal error and one of the windows you were...
Goto Forum:
  


Current Time: Sat Nov 23 10:11:26 CST 2024