What Is a Cursor


What Is a Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL

✍: FYIcenter.com


A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML statement. A cursor is consists of:

  • A DML statement with or without parameters.
  • A status to indicate whether it is connected or not.
  • A pointer to indicate the current row in the resource set.
  • A number of attributes about the cursor, like FOUND, NOTFOUND and ROWCOUNT.

2007-04-29, 4675👍, 0💬