Avatar of Nuno
Nuno
 asked on

Equivalent in Oracle to SET NOCOUNT ON (T-SQL

Hi,

SET NOCOUNT ON is a set statement which prevents the message which shows the number of rows affected by T-SQL query statements. This is used within stored procedures and triggers to avoid showing the affected rows message. Using SET NOCOUNT ON within a stored procedure can improve the performance of the stored procedure by a significant margin.

Is there an Oracle equivalent to this statement ?

Thanks in advance,
* Oracle PL/SQL* T-SQLOracle DatabaseSybase DatabaseDatabases

Avatar of undefined
Last Comment
ste5an

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ste5an

Using SET NOCOUNT ON within a stored procedure can improve the performance of the stored procedure by a significant margin.
This is not correct.

SET NOCOUNT ON only means that the affected row count per statement is not sent to the client. Thus possible decreased network traffic and total time required to complete an call. But the actual performance of a stored procedure is not affected.

Imho Oracle does not transmit a row count per statement in a sproc.
Your help has saved me hundreds of hours of internet surfing.
fblack61