question archive create PL/SQL procedure that given an order id, first check whether this order exists
create PL/SQL procedure that given an order id, first check whether this order exists
Subject:Computer SciencePrice: Bought3
create PL/SQL procedure that given an order id, first check whether
this order exists. If not, print an error message no such order. Then compute the total cost equals the sum of each item's price * quantity in the order plus a 10% delivery fee. The procedure finally updates the g_order table to set the total column to the computed value (the initial total column has null value).
