Write a stored procedure which receives a customer number (Cust_no) as input, and displays the list of
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date: