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 are indexers?

0 Answers  

How can you control the amount of free space in your index pages?

0 Answers  

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

Is candidate a key?

0 Answers  

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

What are subqueries in sql server? Explain its properties.

0 Answers  

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

What is database replication?

0 Answers  

What are triggers in ms sql server?

0 Answers  

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,