OraFAQ Forum: General » need to find how to get row count not to return

Home » Other » General » need to find how to get row count not to return

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need to find how to get row count not to return [message #103158]

Fri, 21 February 2003 13:36

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?

Report message to a moderator

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

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 12 23:14:35 CDT 2026