Interested to Buy Any Domain ? << Click Here >> for more details...
what is the cursor life span?
- 5 Answers
- 14511 Views
- Evalueserve, HG, I also Faced
- E-Mail Answers
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 have included columns when we talk about sql server indexing?
Where can you add custom error messages to sql server?
How to select true false based on column value in sql server?
What is a trace frag? Where do we use it?
Explain foreign key in sql server?
Which sql server table is used to hold the stored procedure script?
What is the difference between for auto and for nested?
what is joins please explain breffly ??
What is an execution plan? How would you view the execution plan?
Do you know what are various aggregate functions that are available?
What is Replication?
Does sql server use t sql?
-
Oracle (3259) - 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)
