what is the cursor life span?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / dinesh gupta

5 Answers
14534 Views
Evalueserve, HG, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the cursor life span?..

Answer / nageswara rao.g

hi friends this is answer as per me,

when static cursor used the cursor lifespan is within
the program only(pl/sql program).its life end when it comes
outside the program
when dynamic cursor is used the cursor is accessable by
outside other programs with in same connection ,not another
connection.i.e its lifespan is with in connection

Is This Answer Correct ?

5 Yes

1 No

what is the cursor life span?..

Answer / gunjan sapra

hi neeraj,
this is not the answer.
answer about the life span of curser.

Is This Answer Correct ?

1 Yes

3 No

what is the cursor life span?..

Answer / sumit

The Life Span of the Cursor is till the runtime of the
stored procedure/function in which the cursor is being used
in sql server

Is This Answer Correct ?

0 Yes

2 No

what is the cursor life span?..

Answer / neeraj

when curser starts and that is curser life span

Is This Answer Correct ?

2 Yes

5 No

what is the cursor life span?..

Answer / sumit

The Life Span of the Cursor is till the runtime of the
stored procedure/function in sql server 2005

Is This Answer Correct ?

0 Yes

4 No

Post New Answer