Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7269 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 rebuild an index in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
How can I create database in oracle?
How to calculate date and time differences in oracle?
What is columnar storage what is the advantage?
How to create a new table by selecting rows from another table?
How to write a query with a left outer join in oracle?
How to resolve the ORA-39133 error in Oracle?
How to convert csv to table in oracle?
How to create a stored program unit?
What is coalesce function?
How to run queries on external tables?
How do I learn what codesets are available in oracle?
How do I spool in oracle?
Give syntax for SQL and ORACLE joins.
