create PL/SQL procedure that given an order id, first check whether this order exists

Computer Science Dec 08, 2021

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).