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
How to change the ownership of a schema in ms sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How can we solve concurrency problems?
What is the difference between varchar and varchar types?
How do I manually uninstall an instance of sql server 2016?
what are different types of backups available in sql server? : Sql server database administration
What are date and time data types in ms sql server?
What is indexing in sql server with example?
Describe different Processing Modes offered by SSRS?
What is nolock?
How to sort the query output with order by clauses in ms sql server?
What is sub-query in sql server?
Define inner join in sql server joins?
What is difference between rownum and rowid?
what are the core components of SSRS?