what is the cursor life span?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How to find the version of sql server? : sql server database administration
What is apply operator in sql?
How to concatenate two strings in SQL Server.
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is truncate table?
What are the steps need to be take improve the speed of a SQLDATA Server?
Write a sql query to get zero records from a table having n number of records?
What is bcp? When does it used?
What is default constraint?
What do you mean by authentication modes in sql server?
How to stop a loop early with break statements in ms sql server?
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)