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

Do you know what is difference between index seek vs. Index scan?

0 Answers  

---

Why use sub query in sql server and list out types of sub queries?

0 Answers  

---

How many columns can we include on clustered index ?

0 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

What the different types of Replication and why are they used?

0 Answers  

---

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

How do you debug a procedure in sql server?

0 Answers  

---

How do you delete a trigger?

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Normalization and denormalization

3 Answers   Wipro,

---

How to truncate a table first before running a package?

1 Answers  

---

What is always encrypted?

0 Answers  

---