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

Answer / gunjan sapra

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

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

Answer / neeraj

when curser starts and that is curser life span

Answer / sumit

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

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

What is dbcc?

0 Answers  

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

in how many ways we can use count()

2 Answers  

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

What are “phantom rows”?

0 Answers  

What are the different sql server versions?

0 Answers  

What is the use of @@spid?

0 Answers  

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

What triggers long term care?

0 Answers  

What do you understand by sql server agent?

0 Answers