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


Please Help Members By Posting Answers For Below Questions

how can we store any pdf file in oracle

1886


What is the difference between Delete, Truncate and Drop in Oracle?

879


How to get a list of all background sessions in the database?

762


Write a syntax for update query in oracle?

815


Explain index?

1017


How to shutdown your 10g xe server?

850


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2351


What is Undo Management Advisor in Oracle?

832


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2012


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1833


Can we convert a date to char in oracle and if so, what would be the syntax?

798


Can we save images in a database and if yes, how?

833


How to use attributes of the implicit cursor in oracle?

792


How to load a large xml file?

836


does the query needs a hint to access a materialized view?

1673