what are the different types of cursors? explain?
Answers were Sorted based on User's Feedback
Answer / srilakshmi paleti
1)Implicit cursor
2)Explicit Cursor
EXPLANATION OF
1)IMPLICIT CURSOR : When ever user performs any DML
operation automatically implicit cursors will raise. User
noneed to create,open,fetch,close the cursor.In PLSQL
select statement also it will work.
2)EXPLICIT CURSOR: User has to create,open,fetch and close
the cursor.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / mohan
Cursor: Cursor is a pointer which is used to fetch one by one record from active set into plsql block.
Types: There are two types of cursors we have in plsql.
they are,
1. Implicit Cursors
2. Explicit cursors
1.Implicit cursors: when ever we perform sql operations then automatically implicit cursors will come into the picture. no need to declare,open,fetch and close implicit cursors.
2.Explicit cursors: These are user defined cursors. we have to declare,open,fetch and close these cursors.
Cursor Attributes:
1.%found
2.%notfound
3.%isopen
4.%rowcount
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / manish kumar
Implicit cursor is declered by System its own But Explicit
cursor is declered by user
Is This Answer Correct ? | 1 Yes | 1 No |
How to check your oracle database 10g xe installation?
How does the on-delete-cascade statement work?
How to retrieve first and last records from a table?
how to insert the image in table
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
How can we delete duplicate rows in a table?
List the various oracle database objects?
What are the uses of synonyms?
Define Normalization with example?
How to update values in a table in oracle?
What is Library Cache in Oracle?
what are actual and formal parameters?