Fetching and updating cursors Chat rooms couples

18 Dec

It is created on a SELECT Statement which returns more than one row. General Syntax for creating a cursor is as given below: In the above example we are creating a cursor ‘emp_cur’ on a query which returns the records of all the employees with salary greater than 5000. When the data is fetched it is copied to the record or variables and the logical pointer moves to the next row and it becomes the current row.Here ‘emp_tbl’ in the table which contains records of all the employees. On every fetch statement, the pointer moves to the next row.

fetching and updating cursors-44

In this chapter, we will discuss the cursors in PL/SQL. A cursor holds the rows (one or more) returned by a SQL statement.

One thing you may notice right away in the May release is that we've changed the default value of several settings.

Features such as minimap (outline view), icon themes, and indent guides have been off by default and we think they are so useful, we want to showcase them.

You can not directly assign value to an explicit cursor variable you have to use expression or create subprogram for assign value to explicit cursor variable.

A cursor is a temporary work area created in the system memory when a SQL statement is executed.