What Is a Cursor in Oracle

Q

What Is a Cursor in Oracle?

✍: FYIcenter.com

A

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.

 

Working with Cursors in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-17, 222👍, 0💬