Oracle updating cursor

Rated 3.94/5 based on 993 customer reviews

Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row.

In the above sample, I am selecting a value from TABLEX.Both implicit and explicit cursors have the same functionality, but they differ in the way they are accessed.When you execute DML statements like DELETE, INSERT, UPDATE and SELECT statements, implicit statements are created to process these statements.If none of the employee’s salary are updated we get a message 'None of the salaries where updated'.Else we get a message like for example, 'Salaries for 1000 employees are updated' if there are 1000 rows in ‘employee’ table.

Leave a Reply