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
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Differentiate between a primary key and a unique key.
What is the meaning of sql server?
Explain what are commit and rollback in sql?
Tell about MOM Tool(Microsoft Operator Manager)?
What is a derived table?
Does transparent data encryption provide encryption when transmitting data across the network?
how many bits ip address consist of? : Sql server database administration
What are examples of triggers?
What are the advantages of log shipping?
what are different types of raid configurations? : Sql server database administration
Write a program using SQL queries to find a unique entry in a table.
Explain transaction isolation levels in sql server?
What is use of except clause? How does it differ from not in clause?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration