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 |
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
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>
Explain about the relational database?
What is an application role and explain a scenario when you would use one?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are the disadvantages of cursors? How can you avoid cursors?
Why does this query return 0?
Explain about query and reporting.
What are the key features of dbms?
How can you fix a poorly performing query?
What are the three basic rules which are to be followed for the relational model of the database?
Where is dbms used?