Oracle SQL % rowcount returns the number of affected rows

 

In sqlserver, the number of affected rows returned is: If @ rowcount <1

In Oracle, the number of affected rows returned is: If SQL % rowcount <1

Example:

Sqlserver:

Asbeginupdate t_mt set stat = @ stat, ostat = @ stat, rpttime = getdate () where msgid = @ msgidif @ rowcount <1 -- inserted to t_statbufinsert into t_statbuf (msgid, stat, rpttime) values (@ msgid, @ stat, getdate () End

ORACLE:

Create or replace procedure testasbegin update my_time_test1 set disallow = '6' where disallow = '1 '; if SQL % rowcount> 1 then -- insert into my_time_test1 values (sysdate, '7'); end if; end;