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 |
What is a trigger and what are its types?
What are triggers in oracle?
Explain the use of indexes option in exp command.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How view is different from a table?
What is an oracle data file?
how to find the n'th highest salary from emp ?
What is MTTR advisor in Oracle?
How to set up autotrace for a user account?
How to divide query output into groups in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
How to put more than 1000 values into an oracle in clause?