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
How to rename an index?
How to get execution statistics reports on query statements?
What is the difference between Delete, Truncate and Drop in Oracle?
Explain the importance of .pll extension in oracle?
What is system tablespace?
How to create a table index?
How to connect to the server with user account: sys?
List out the components of logical database structure of oracle database.
Explain an integrity constrains?
Can you drop an index associated with a unique or primary key constraint?
How do I reset a sequence in oracle?
How to use "for" statements in oracle?
What are joins, explain all types of joins?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is a package ? What are the advantages of package ?