quickly pls (:

Based on the following tables: (10 points] Towe CUSTOMERS Cust10 Cust_name Street 1066 Bundy Shoe King St 13144 Target High St 1776 Harry Store Elphun Rd 2001 Kmart Burke Rd 2002 Qahoe Glen Rd Cel 500 Postcode Bundoor 305) Clayton 3800 Hawthorn 3122 Kew 3101 3101 Currbal 450 3000 500 O Kew 500 500 1000 PRODUCTS Prod_cod Description Pred group MO9 L09 STI LTI LT9 GN9 STI GA2 Male Runner Lady Runner Girls Runner Tennis Shoe Terms Shoe Beach Sandal Slapper Soccer Shoe Male Shoes Female Shoes Female Shoes General General General General Male Shoes Prod price 150 250 300 450 100 10 SO 500 Qty. hand 6 1 10 1 20 100 50 10 Remake Level 3 1 5 2 15 150 35 15 Remake 90 5 3 15 2 20 200 20 40 ORDERS Order no 0001 0002 0003 Order date 01/07/05 02/07/05 02/07/05 Cast Do 13144 13144 1066 ORDER DETAILS Order no Prod cod 0001 STI 0001 GA2 0002 STI 0003 GN9 Order by 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) Orar Sedang win B) Given the following trigger using the tables above, check the code of this trigger CREATE OR REPLACE TRIGGER RejectOrder BEFORE INSERT ON Orders FOR EACH ROW DECLARE currentBalance NUMBER: creditLimit NUMBER: BEGIN SELECT Cr_limit, Cr_balance INTO creditLimit, current Balance FROM Customers WHERE Cust_no new.Cust_no IF creditLimit