Question I
i. Create a procedure that accepts a customer id and retrieves the id of the products and quantities that the customer ordered.
ii. Use an anonymous to call the procedure and output the result.
Question II
i. Create a procedure to insert a row into the product table with appropriate values
ii. Use an anonymous to call the procedure and output the result.
Question III
i. Create a procedure that accepts a category name and retrieves the Product and the total sales for the category.
ii. Use an anonymous to call the procedure and output the result.
Question IV
i. Create a stored procedure to retrieve the n most expensive
ii. Products, where n is a number. Use an anonymous block to call
iii. The stored procedure and display the results.
iv. Use an anonymous to call the procedure and output the result.