State the difference between implict and explict cursor's?
Answer Posted / swapna
Implicit Cursor are declared and used by the oracle
internally. whereas the explicit cursors are declared and
used by the user.
more over implicitly cursors are no need to declare oracle
creates and process and closes autometically. the explicit
cursor should be declared and closed by the user.
More over Explicit Cursors were used to retrieve values
from two or more rows.
Is This Answer Correct ? | 28 Yes | 2 No |
Post New Answer View All Answers
What are pl sql data types?
What is the difference between the implicit and explicit cursors?
What are the types of index in sql?
How do you write an index?
What is sql profiler in oracle?
Can function return multiple values in sql?
What does rownum mean in sql?
Why we use join in sql?
Is natural join and inner join same?
How can you tell the difference between an index and a view?
What is the best free sql database?
What is the difference between rollback and rollback to statements?
What is the use of sql trace?
define join and explain different type of joins? : Sql dba
How to Execute a Package in PL/SQL.?