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 |
What is the difference between DATETIME2 and DATETIME?
What is the stored procedure?
How to perform backup for certificates in sql server? : sql server security
What security features are available for stored procedure?
What is an extended Stored Procedure?
What is the syntax to execute the sys.dm_db_missing_index_details?
How do I create a stored procedure in dbml?
What is default port number for sql server 2000?
what is bit datatype? : Sql server database administration
Explain a join?
Write an sql query to find the names of employees start with ‘a’?
What is self contained sub query?
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)