CodesJava

Easy learning with example program codes

How to declare a cursor?


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.

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

See more at: Plsql cursor.

Related topics

Sign Up/ Sign In
Ask a Question


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki