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 assign a tablespace to a users in oracle?
Explain the use of owner option in exp command.
Explain enable novalidate constraint.
What happens to indexes if you drop a table?
What is a tns file?
What happens in oracle commit?
What is an oracle wallet?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Explain the use of grant option in exp command.
Which is better Oracle or MS SQL? Why?
Why cursor variables are easier to use than cursors?
what are actual and formal parameters?
How does Oracle guarantee data integrity of data changes?
How to turn on or off recycle bin for the session?
Explain the use of consistent option in exp command.
