Cursor ROWCOUNT « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. Cursor ROWCOUNT
1.Cursor attributes: FOUND NOTFOUND, ROWCOUNT
2.modified the cursor FOR LOOP presented earlier to include %ROWCOUNT:
3.IF csr_org%ROWCOUNT = 1 THEN
4.Check SQL%ROWCOUNT after update statement
5.Implicit Cursor Attributes: If the previous UPDATE statement didn't match any rows, insert a new row into the place table
6.Demonstrates the %ROWCOUNT cursor attribute by using a single-row implicit cursor based on the DUAL pseudotable
7.sql%rowcount macro