Answer Posted / 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
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
can SSRS reports Cache results?
List some case manipulation functions in sql?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Tell me about joins in database system and explain each in detail.
What is report snapshot in ssrs?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Can we create clustered index on composite key?
What is bcnf normalization form?
What is create command?
Do you know what is xpath?
How to create and drop temp table in sql server?
How to create a scrollable cursor with the scroll option?
What are views used for?
How to create dbo table in sql server?
What is postgresql server?
