Plsql updating in cursor updating process for blackberry

Posted by / 01-Jun-2020 13:04

Plsql updating in cursor

Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row.When you fetch a row the current row position moves to next row.Oracle provides few attributes called as implicit cursor attributes to check the status of DML operations.The cursor attributes available are %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN.They are also created when a SELECT statement that returns just one row is executed.They must be created when you are executing a SELECT statement that returns more than one row.

Else we get a message like for example, 'Salaries for 1000 employees are updated' if there are 1000 rows in ‘employee’ table.The set of rows the cursor holds is called the set.There are two types of cursors in PL/SQL: These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed.The WHERE CURRENT OF clause in an UPDATE or DELETE statement states that the most recent row fetched from the table should be updated or deleted.We must declare the cursor with the FOR UPDATE clause to use this feature.

plsql updating in cursor-85plsql updating in cursor-60plsql updating in cursor-15

SCROLL Specifies that all fetch options (FIRST, LAST, PRIOR, NEXT, RELATIVE, ABSOLUTE) are available.