Give which cursor is better for better performance means
type of cursors?

Answer Posted / swapna

If you deal with better performance You have to refer REF
CURSOR and its more advantage and effecient of Execution.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between truncate and drop statements?

571


How do I know if I have sql express or standard?

595


What is scalar function?

564


How to display the records between two range in Oracle SQL Plus?

636


Are subqueries better than joins?

527






Is record in pl sql?

513


What are the types of records?

526


Is left join and outer join same?

542


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

661


Why is sql better than hql?

504


What are some emotional triggers?

568


How exception is different from error?

539


how to dump a table to a file with 'mysqldump'? : Sql dba

547


What is clause?

608


Why primary key is required?

553