Oracle与SQL Server的SET NOCOUNT ON等效吗? [英] What is the Oracle equivalent of SQL Server's SET NOCOUNT ON?

问题描述

Oracle等同于SQL Server的SET NOCOUNT ON?

从 SQL Server文档:

SET NOCOUNT ON ...停止返回表示受Transact-SQL语句或存储过程影响的行数计数的消息作为结果集的一部分...

对于包含多个不返回大量实际数据的语句的存储过程，或者对于包含Transact-SQL循环的过程，将SET NOCOUNT设置为ON可以显着提高性能，因为大大减少了网络流量.

解决方案

在存储过程中使用set nocount on时，在Oracle中没有等效项，仅仅是因为没有必要(在过程或函数内部)执行. /p>

BigMike提到的唯一模糊匹配的东西是set feedback off

What is the Oracle equivalent of SQL Server's SET NOCOUNT ON?

From the SQL Server documentation:

SET NOCOUNT ON... Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set...

For stored procedures that contain several statements that do not return much actual data, or for procedures that contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly reduced.

解决方案

There is no equivalent in Oracle when set nocount on is used inside a stored procedure, simply because it's not necessary to do (inside a procedure or function).

The only vaguely matching thing is set feedback off as mentioned by BigMike

这篇关于Oracle与SQL Server的SET NOCOUNT ON等效吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！