Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7526 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
What is redo log?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How can you merge two tables in oracle?
How to write date and time interval literals in oracle?
What is the usage of merge statement?
What is ordinary table in oracle?
Explain alias?
How to define default values for formal parameters?
How to sort the query output in oracle?
What is an external table?
What are the restrictions in a oracle read only transaction?
6. Display the client name and order date for all orders using the traditional method.
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is tns name?
Why do we use bulk collect in oracle?
