Oracle Database Interview Question:

What Is a Cursor in Oracle?

Submitted by: Administrator

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.

Submitted by: Administrator