Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sohini
Whenever you issue a SQL statement, the Oracle server opens
a SQL work area in memory in which the command is parsed
and executed. This area is called a cursor.There are two
type of cursors:
Implicit Cursor:PL/SQL declares a cursor implicitly for all
SQL data manipulation statements, including queries that
return only one row.PL/SQL manages this cursorautomatically.
Explicit Cursor:The programmer explicitly declares and
names an explicit cursor for queries that return more than
one row.it is managed by the programmer.
Explicit cursors are used when one wants to do some
processing with a set of rows fetched from a table or
multiple table.They are managed using OPEN,FETCH and CLOSE.
4 attributes are used in both types of cursors:%FOUND,%
NOTFOUND,%ROWCOUNT and %ISOPEN.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to import one table back from a dump file?
What is concurrency in oracle?
How to see free space of each tablespace?
Explain the use of record length option in exp command.
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How can we find out the duplicate values in an oracle table?
What is bulk load in oracle?
Which is faster join or subquery in oracle?
What are privileges and grants?
How to create an initialization parameter file?
How to join two tables in a single query using oracle?
What is the difference between truncate & delete command?
What are the differences between lov and list item?
How to pass a parameter to a cursor in oracle?
How to set a transaction to be read only in oracle?
