While executing INSERT/DELETE/UPDATE statements you can see the number of rows effected displayed at the bottom of the sqldeveloper, as shown in the screenshot below.
![](https://sites.google.com/site/formypersonaluse1/business/siterelated/sqlrows.PNG?attredirects=0)
To capture the number of effected rows, during conversion/interface run, to properly audit the actual number of rows effected, %SQLrows can be used.
PeopleBooks Definition:
%SQLRows returns the number of rows affected by the most recent UPDATE, DELETE, or INSERT executed through the SQLExec function.
%SQLRows can also be used after SELECT. It returns 0 if no rows are returned, a non-zero value if one or more rows are returned. In this case, the non-zero value does not indicate the total number of rows returned.
This will be useful and handy at times.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMUTH7qOqaoEX5gv-9ParSclzIIT2knCyNVjUlsMRVtV2yCERRhD2OlKNDxDcvA2IcIywvz3rEJQgHIMv5zjKFUOdgLykblTY0mj3GUDSQamXxw5_9N_hn65QxjGUDhpPXYOrVQmlLGb4/s400/mani.PNG)
To capture the number of effected rows, during conversion/interface run, to properly audit the actual number of rows effected, %SQLrows can be used.
PeopleBooks Definition:
%SQLRows returns the number of rows affected by the most recent UPDATE, DELETE, or INSERT executed through the SQLExec function.
%SQLRows can also be used after SELECT. It returns 0 if no rows are returned, a non-zero value if one or more rows are returned. In this case, the non-zero value does not indicate the total number of rows returned.
This will be useful and handy at times.
No comments:
Post a Comment