Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of cursors? explain?
- 4 Answers
- 10030 Views
- I also Faced
- E-Mail Answers
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 convert times to characters in oracle?
What is the use of file param in imp command?
What is system tablespace?
25. Display the client number and the value of the highest value order placed by that client.
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How to find no of saturdays in a month using single sql ?
Does rowid change in oracle?
How to convert numbers to characters in oracle?
What is Hash Cluster ?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Whether any commands are used for months calculation? If so, what are they?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Oracle General 
