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
What are partitioned views?
What are the different authentication modes in sql server?
How to create a new table in a given schema?
Explain different backup plans?
Explain throw statement in sql server 2008?
State the difference between union and union all?
Explain something about security and SQL Azure?
What is 2nf in normalization?
what stored procedure can you use to display the current processes? : Sql server administration
Comment,Datatypes are unlimited
Tell me about normalization in DBMS.
What is replication and database mirroring?
what is the difference between openrowset and openquery?
What is the difference between composite index and covering index?
What the class forname () does?