Description
- Write a stored procedure that processes the CUSTOMER table reporting on the number of customers in each country that exceed the number passed to the procedure. For the example below, Australia with a count of 5 customers is not included in the output. Your procedure should include a COUNTRYIN CHAR(15) and a TOTALCUST NUMBER variable that is loaded with the appropriate country and country total for each line of output. Use %Rowcount to determine the number of rows returned. (5 marks)
- Use two while loops in a procedure with the following results. If anything else is passed, do not execute the loops.
(5 marks)
| EXECUTE MYWHILELOOPS(‘E’)
|
EXECUTE MYWHILELOOPS(‘O’)
|
EXECUTE MYWHILELOOPS(‘W’)
