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 is the difference between the sql*loader and import utilities? : aql loader
What are the types of functions in sql?
what is the command line end user interface - mysql? : Sql dba
What are the types of sql commands?
What is materialized view. What are different methods of refresh?
What is the usage of distinct keyword?
What is the largest value that can be stored in a byte data field?
What is dml and ddl?
What are different types of tables in sql?
What is sql injection owasp?
What is left join in sql?
What are synonyms in sql?
What is the difference between the implicit and explicit cursors?
How do I save a stored procedure?
What is the source code of a program?