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.