what are the different types of cursors? explain?

Question Posted / jakki

4 Answers
10017 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the different types of cursors? explain?..

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

what are the different types of cursors? explain?..

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

what are the different types of cursors? explain?..

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

what are the different types of cursors? explain?..

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

Post New Answer