Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7401 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 the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is open database communication (odbc) in oracle?
State any two functions of oracle?
How to write numeric literals in oracle?
Please explain oracle left join with an example?
What are the different windows events activated at runtime ?
How do I uninstall oracle client from windows?
what is a Nested Loop join?
What is archive log in Oracle?
Why is oracle database so popular?
What are the different types of synonyms?
How to rename a column in an existing table?
Can we protect our pl/sql source code?
How to delete all rows a table in oracle?
State and explain the different types of data models?
