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 do you understand by concurrent programs?
Tell me how to find the custom directory in front end?
In sequence i want to 11 and 15th values how we will write?
How can we import the data into a database using sql * loader?
Can you define an erp system?
tell me the scenarios of the independent in reports
What are the benefits of using soa architecture?
how can i print random rows in plsql table
what are the different transaction clauses in AR?
What is instead of trigger in where we will use?
Which oracle apps version you are very confident in?
Explain oracle apps architecture.
How can you achieve loose coupling in soa framework?
What is a flexfield? List out its types.
What do you understand by soa?
