After a shopper completes an order a procedure is called to


Solve this problem using SQL queries.

Question: After a shopper completes an order, a procedure is called to update the following columns in the Basket table: orderplaced, subtotal, shipping, tax and total.

The value 1 entered in the ordereplaced column indicates that the shopper has completed an order. Inputs to the procedure are the basket id and amounts for the subtotal, shipping,, tax, and total.

1. Create a procedure named basket_confirm_sp that accepts the input values specified in the preceding description.

Keep in mind that you're modifying an existing row of the bb_basket table in this procedure.

Call the procedure with the following parameter values: 17, 64.80, 8.00, 1.94, 74.74.

As mentioned, these values represent the basket ID and the amounts for the subtotal, shipping, tax and total.

Design the procedure and implement in SQL.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: After a shopper completes an order a procedure is called to
Reference No:- TGS0943480

Expected delivery within 24 Hours