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
What is a value set? List its various types.
What are the Standard Reports and Forms in HRMS?
is it possible to run the interface without using oracle apps?
Are you familiar with internet architecture of oracle apps 11i?
please send me forms, xml pulisher questions,answers
Can we create tables in apps schema?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Plz anybody send me Technical specification for AP Interface
tell me the scenarios of the independent in reports
What is the concept of soa governance?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How can a process be deployed in soa?
testing tools?
Explain what are the tables of auto invoice?
How is choreography different from orchestration?
