Difference between an implicit & an explicit cursor.?
- 2 Answers
- 6779 Views
- I also Faced
- E-Mail Answers
Answer Posted / v.ramesh
Implicit cursor is taken care by oracle server only,when we write any statement or query in the SQL editor,in that case oracle server create some memory for that and do operation on that query and finally erase the space as well
in case of Explicit cursor,manually like we need to create the Cursor and open.fetch the data and close the cursor.
we have one more alternative for this,if we will create cursor we need to user FOR LOOP mechanism in this case all exlicit cursor are not needed i.e OPEN<FETCH<CLOSE
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I spool to a csv formatted file using sqlplus?
What is tns name?
What is the string concatenation operator in oracle?
How a tablespace is related to data files?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is Library Cache in Oracle?
How view is different from a table?
How to pass a parameter to a cursor in oracle?
Write a trigger example in oracle?
Explain the use of tables option in exp command.
Why does for update in oracle 8 cause an ora-01002 error?
How to export your own schema?
How to use group functions in the select clause using oracle?
What is a view and how is it different from a table?
What would you do with an in-doubt distributed transaction?
