Difference between an implicit & an explicit cursor.?
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 can we store any pdf file in oracle
What is the difference between Delete, Truncate and Drop in Oracle?
How to get a list of all background sessions in the database?
Write a syntax for update query in oracle?
Explain index?
How to shutdown your 10g xe server?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is Undo Management Advisor in Oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Can we convert a date to char in oracle and if so, what would be the syntax?
Can we save images in a database and if yes, how?
How to use attributes of the implicit cursor in oracle?
How to load a large xml file?
does the query needs a hint to access a materialized view?