Answer Posted / amit basu
Types of Cursor :
I) Implicit
II) Explicit (Explicit cursor has three sub-types)
1) Simple Cursor
2) Parameterised Cursor
3) Reference Cursor
EXPLANATION OF
I) Implicit--- SINGLE USER ONLY
II) Explicit ----- MULTI USER ONLY
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the dynamic sql in oracle?
Can we write insert statement in function in oracle?
what is the difference between functional dependecy and multilevel dependency?
What is meant by joins? List out the types of joins.
How to load a large xml file?
What is varray?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is the scope of a local variable?
How are extents allocated to a segment?
What happens if recursive calls get out of control?
What are the limitations oracle database 10g xe?
Can sub procedure/function be called recursively?
How to get a list of all background sessions in the database?
What do you understand by a database object?
How can I create database in oracle?
