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
What is the difference between $oracle_base and $oracle_home?
What is an oracle table?
What are the attributes of cursor?
Difference between open_form and call_form in oracle.
How to drop a tablespace?
What is a proxy object?
Explain rename?
Can we connect to ORACLE db using Windows Authentication?
How to estimate disk space needed for an export job?
How to create a stored procedure in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
Explain the difference between sql and oracle?
what is Single Byte Overhead...?
How can windows applications connect to oracle servers?
Explain the use of indexes option in imp command.
