Database Reference
In-Depth Information
▼
Output
+-----------+---------+
| order_num | total |
+-----------+---------+
| 20005 | 158.86 |
| 20006 | 58.30 |
| 20007 | 1060.00 |
| 20008 | 132.50 |
| 20009 | 40.78 |
+-----------+---------+
And then you have it, a complete working example of stored procedures, cur-
sors, row-by-row processing, and even stored procedures calling other stored
procedures.
In this chapter, you learned what cursors are and why they are used. You also
saw examples demonstrating basic cursor use, as well as techniques for looping
through cursor results and for row-by-row processing.
