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
Explain what are the tables of auto invoice?
How can a process be deployed in soa?
Is soa a part of oracle fusion middleware?
In support project one ticket alloted which steps follows manualy tell me ?
What are the different components you should consider while defining a responsibility in oracle apps?
what is pay run id ?
What do you understand by a set of books?
Tell me how to debug the report?
List the various types of value set.
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What is the concept of soa governance?
What is count(*) from po_vendors(any table)?
What are the different components of soa suite?
Can u give the Documentation of Custom.pll in oracle apps
