Write a stored procedure which receives a customer number (Cust_no) as input, and displays the list of orders made by the customer together with the total price of each of the orders 

 (columns to display: order_no, order_date, total_price: (Prod_price* Order_qty) (using the DBMS_OUTPUT.PUT_LINE)

  

CUSTOMERS Cust_no Cust_name 1066 Bundy Shoe 13144 Target 1776 2001 2002 PRODUCTS Prod_cod Description M09 LO9 ST1 Harry Store Kmart Qshoe LT1 LT9 GN9 STI GA2 Male Runner Lady Runner Girls Runner Tennis Shoe Tennis Shoe Beach Sandal Slipper Soccer Shoe Street Kings St High St Elphin Rd Burke Rd Glen Rd Town Bundoora Clayton Hawthorn Kew Kew Prod_group Male Shoes Female Shoes Female Shoes General General General General Male Shoes Post code 3083 3800 3122 3101 3101 Prod Qty_on_ Remake price hand level 150 250 300 450 100 10 50 500 Cr limit 500 3000 500 500 1000 6 1 10 1 20 100 50 10 3 1 5 2 15 150 35 15 Curr bal 450 3000 500 0 1000 Remake_ qty 5 3 15 2 1888 20 200 20 40