Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7431 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 to connect to the server with user account: sys?
How to define a variable to match a table column data type?
What do you mean by merge in oracle and how can we merge two tables?
When do you get a .pll extension in oracle?
does the query needs a hint to access a materialized view?
What is a subquery?
Why do we use bulk collect in oracle?
Give the constructs of a package, function or a procedure.
How view is different from a table?
Explain integrity constraints?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Calculate difference between 2 date / times in oracle sql?
How to assign data of the deleted row to variables?
What are the different types of partitions in oracle?
How to synchronize 2 schema's objects?
