Answer Posted / tulsi
The cursor having query as SELECT .... FOR UPDATE gets
closed after COMMIT/ROLLBACK.
The cursor having query as SELECT.... does not get closed
even after COMMIT/ROLLBACK
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference between inner and outer join? Explain with example. : Sql dba
How many subqueries can be nested in a statement?
What is the use of sqldataadapter?
what is msql? : Sql dba
What are the types of records?
What is Histogram?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is left join in sql?
Can ddl statements be used in pl/sql?
What is row_number () in sql?
Why stored procedures are faster than query?
what happens if you no create privilege in a database? : Sql dba
What is package in pl sql?
What are different sql data types?
what are the different index configurations a table can have? : Sql dba