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 is the difference between seek predicate and predicate?
how many no of arguments can be passed in procedures and functions
Why use update_statistics command in sql server?
List all types of constraints in sql server?
What is clr ddl trigger?
What is the usage of sign function?
What is sql view?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
According to you what goes into making the best database administrator? : sql server database administration
How to generate create table script on an existing table in ms sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Give a example to search fr a string in all stored procedure in sql server.
How you can get a list of all the table constraints in a database?
What are some examples of schemas?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration