Answers were Sorted based on User's Feedback
Answer / highness
locks will be released
changes will be made permanent
|Is This Answer Correct ?||3 Yes||0 No|
Answer / 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|
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is sql a microsoft product?
Is inner join faster than left join?
How do I turn a list into a table?
What is a call statement? Explain with an example.
Is left join same as join?
Please let me know if UNION ALL and Natural Join does the same operation and are same...
What is 19 null in sql?
What are nested triggers ?
What is database white box testing and black box testing?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
What is a unique key and primary key and foreign key?