State the difference between implict and explict cursor's?
- 7 Answers
- 21697 Views
- CTS, I also Faced
- E-Mail Answers
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 db journal file?
what is cursor. write example of it. What are the attributes of cursor.
What are analytic functions in sql?
What are sql data types?
What is the file extension for sql database?
What are two statement types in sql?
Is primary key an index?
how is exception handling handled in mysql? : Sql dba
What are some emotional triggers?
What are secondary keys?
What is informix sql?
What is the difference between sql and mysql?
Can we debug stored procedure?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is union, minus and interact commands?
