Types of cursors and explanation each of them ?

Question Posted / hemanth desai

4 Answers
11629 Views
DELL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Types of cursors and explanation each of them ?..

Answer / sohail

Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.

Is This Answer Correct ?

8 Yes

4 No

Types of cursors and explanation each of them ?..

Answer / anusha

Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.

Is This Answer Correct ?

1 Yes

0 No

Types of cursors and explanation each of them ?..

Answer / giri

Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.sql%found,sql%notfound,sql%is open,sql%count these are the implicit cursor attributes.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.%found,%notfound,%is open,%count these are the explicit cursor attributes.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.

Is This Answer Correct ?

1 Yes

0 No

Types of cursors and explanation each of them ?..

Answer / aditya

Ref cursor have two types strong ref cursor and weak ref cursor.

declaring a ref cursor and using it for multiple select statements is a weak cursor.

using a ref cursor as an out parameter to get a result set is a strong ref cursor.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer