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
Who developed sql?
Are null values same as that of zero or a blank space?
Is it possible to read/write files to-and-from PL/SQL?
What does inner join mean?
What are tables and fields?
What is the use of function "module procedure" in pl/sql?
what is a database transaction? : Sql dba
What are the types of views in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
How can we solve sql error: ora-00904: invalid identifier?
What is the difference between a subquery and a join?
How to pipe multiline string to isql?
what is a relationship and what are they? : Sql dba
Why is sharding used?
Is pl sql still used?