Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / fahad iqbal
A cursor is a handle (pointer) in memory for a DML operation
(Select , Update).
There are mainly 2 types of cursors .
1) Implicit Cursor.
2) Explicit Cursor.
Implicit cursor: Oracle will implicitly creates an area for
the DML operations. Programmer will not have control on
implicit cursors. The only useful attribute on this implicit
cursor is SQL%ROWCOUNT , it will give the number of rows
affected by the recent DML operation.
The only Implicit cursor is SQL.
Explicit Cursor:
Explicit cursors are created by the programmer and
programmer have control on it
Programmer can
1) Open
2) Close
3) Fetch
and do some manipulations on the values
Explicit Cursors are classified into
1) Normal cursor
2) Parameterized cursor
3) Cursor For Loops and
4) REF cursors
REF Cursors:
Normally when we create a normal cursor , we cant change the
select query associated to that query (the query which is
given at the time of definition)
But using REF cursors , we can change the cursor statement also.
These REF cursors are useful when we are sending data from
one environment to another environment.
Thanks And Regards
FAHAD IQBAL
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
How do you register report in oracle apps?
how to print multi lay outs,muti currency,muti language in xml publisher
What are the benefits of using soa architecture?
how do you describe O2C along with tables
how can i print random rows in plsql table
Do you know what are user profiles in apps. Any examples you can give?
How can a process be deployed in soa?
where to define interorganization transaction charges and what are the different options?
what is the differences between internal requisition and internal sales order?
In oracle application how do you debug or trace errors?
In support project one ticket alloted which steps follows manualy tell me ?
Explain what are the tables of auto invoice?
do you know is it possible to run the interface without using oracle apps?
