Easy learning with example program codes

How to declare a cursor?


A cursor is a pointer to context area i.e. Context area is controlled by the cursor. It is used to fetch and manipulate the data returned by the SQL statement.
Note: The set of rows the cursor holds is known as active set.

Declaring the cursor:

CURSOR cur_students IS
   SELECT rollNo, name, address FROM students;

See more at: Plsql cursor.

Please follow and like us:

Copyright © 2020 CodesJava Protection Status