Oracle cursor for updating every row in same table

Rated 3.98/5 based on 633 customer reviews

The cursor attributes available are %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN.

For example, When you execute INSERT, UPDATE, or DELETE statements the cursor attributes tell us whether any rows are affected and how many have been affected. INTO statement is executed in a PL/SQL Block, implicit cursor attributes can be used to find out whether any row has been returned by the SELECT statement. The status of the cursor for each of these attributes are defined in the below table.

When you fetch a row the current row position moves to next row.

' '

Leave a Reply