Question: help me pleeease and write answer in paper pleeease Q7. PL/SQL: Answer the following Questions 110 points) Based on the following tables: CUSTOMERS Curre DontSheek

help me pleeease and write answer in paper pleeease  help me pleeease and write answer in paper pleeease Q7. PL/SQL:
Answer the following Questions 110 points) Based on the following tables: CUSTOMERS
Curre DontSheek TC Izo HP ka 800 312 3100 511011 3000 ESCO

Q7. PL/SQL: Answer the following Questions 110 points) Based on the following tables: CUSTOMERS Curre DontSheek TC Izo HP ka 800 312 3100 511011 3000 ESCO 500 500 TO E00 PRODUCTS Preden Descripti Predgroup Pred Q le MOS LOS Founde Chees price 130 250 300 $50 100 10 1 5 Krok qy 13 13 15 2 10 1 20 100 SO 10 156 200 30 40 500 LTI Geos LT9 She GNO STI Slappe GER GA EUCOS Shoes ORDERS Order be Order date Cars COTTOZOS 13144 0000 69070 1066 ORDER DETAILS Order Prod cod 0001 STI 0001 G4 0002 STI 0003 GN Order 902 10 2 5 10 A. 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 Notes: (columns to display: order_no, order date, total_price: (Prod_price* Order_qty) (using the DBMS_OUTPUT.PUT_LINE) ma 07. PUSQL: Answer the following Questions 110 points Based on the following tables: CUSTOM 100 D IKI 3800 XOO 000 500 2001 . PRODUCTS ved gren Q prie MO ETO 30 3 1 40 10 1 20 100 13 2 IGN 150 50 10 ORDERS Order Onderdele CO2 COM DADO ORDER DETAILS Order Cool 000 04 D002 STI 0001 GV TO 2 3 10 A. 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 Notes: (columns to display: order_no, order_date, total_price: (Prod_price. Order_qty) (using the DBMS_OUTPUT.PUT_LINE)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!