Oracle SQL % rowcount returns the number of affected rows

In SQL server, 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:

[SQL]

1. AS
2. BEGIN
3. UpdateT_MtSetStat = @ Stat, OStat = @ Stat, RptTime = Getdate ()WhereMsgId = @ MsgId
4. If @ RowCount <1-- Insert to t_Statbuf if no update is successful
5. Insert IntoT_statbuf (MsgId, Stat, RptTime)Values(@ MsgId, @ Stat, Getdate ())
6. END

Oracle:

[SQL]

1. CREATE OR REPLACE PROCEDURETest
3. AS
4. BEGIN
5. UpdateMY_TIME_TEST1SetDisallow ='6' WhereDisallow ='1';
6. If SQL % rowcount> 1Then-- Insert the number of rows affected by the above update to my_time_test1 if the number is greater than 1
7. Insert IntoMY_TIME_TEST1Values(Sysdate,'7');
8. EndIf;
9. END;