What are the disadvantages of cursors? How can you avoid
cursors?
Answers were Sorted based on User's Feedback
Answer / rahul kumar
A) In cursors each time you fetch a new row it does a round
trip with the database thereby increase network use and time.
B) There is also restriction on select statements that can be
used in cursors
C) It also uses more resources and temporary memory
Cursors can be avoided with the help of careful
implementation of while loop and other set based operations
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / gogune s k
Overload for RAM to process each row and time consuming.
Bulk collect can be used in place of cursors in some cases.
Is This Answer Correct ? | 3 Yes | 1 No |
What is an extended stored procedure?
What are the three basic rules which are to be followed for the relational model of the database?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
what is difference between primary key and unique key ?
Explain about the storage and physical database design?
State the acid rules?
explain detail about ftp in datastage?
Which four data types cannot be used as a return type from a user-defined function?
1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
How can I detect whether a given connection is blocked?
Explain about a primary key?