Basic Oracle Concepts and Programming Question: Download Questions PDF
What Is a Cursor in Oracle?
Answer:
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.
► 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.
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Define a Variable to Match a Table Column Data Type? | How Many Types of Cursors Supported in PL/SQL? |