Sql%rowcount returns the number of rows affected

In Oracle. Returns the number of affected rows: If Sql%rowcount

Example:

      Update Ut_calenderstatus T      set T.CALENDERSTATUS=PI_FLG,          t.m=pi_m,          t.n=pi_n,          T.prolong=pi_prolong      where T.fundcode=pi_fundcode;      If Sql%rowcount=0 then        inserts into Ut_calenderstatus        values (pi_fundcode,pi_flg,pi_m,pi_n,pi_prolong);      End If;

BEGIN    Update my_time_test1 Set discript = ' 6 ' where discript = ' 1 ';    If Sql%rowcount>1  then--The above update affects the number of rows >1 inserted into the my_time_test1 insert into    my_time_test1 values (sysdate, ' 7 ');    End If; END;

Sql%rowcount returns the number of rows affected