Page 124 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

6 Call The Stored Procedure
Now, call the stored procedure to execute the cursor:
CALL IterateExampleTable();

You should see the data from each row of the example table printed as output.

Question
1 Explain the key components of a cursor declaration in MySQL.
2 When would you use a SCROLL cursor in MySQL, and provide an example?

109
CITS : IT & ITES - Computer Software Application - Exercise 33 CITS : IT & ITES - Computer Software Application - Exercise 33