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 activity monitors
How to see the event list of an existing trigger using sys.trigger_events?
Why main is user defined function?
What is normalization and what are the advantages of it?
what is raid? : Sql server database administration
What are sql server procedures?
How to make conditional sum in ssrs?
Why SQL Agent is used?
How is table type constraint applied to a table?
What is indexing a document?
Explain about remote stored procedure?
what is unique and xaml nonclustered index
How to grant a permission in ms sql server using "grant execute" statements?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Characterize join and name diverse sorts of joins?