Log into your Oracle account and run the script Procedures_Tables.sql to refresh tables for the coffee store database.

(a) Create a PL/SQL procedure that calculates total amount of an order, which includes subtotal and sales tax. Sales tax varies from state to state as listed in the bb_tax table. Name this procedure as your own last name. This procedure takes two input (IN) parameters: name of the state and order subtotal. The procedure has one output (OUT) parameter for total amount of the order (which is subtotal plus sales tax). Amount of sales tax on the subtotal is calculated using the given states tax rate (state rates are listed in BB_TAX table). (b) Compile the procedure and make sure it compiles successfully. Make a screenshot of the complete procedure and its compilation message and paste it in a Word document. (An example of the compilation message is shown below your screenshot should show both the procedure and compilation message.)

"Procedure TAX_CALC complied

Test the procedure by calling it in a PL/SQL block, such as the following (your procedure name would be different). Make a screenshot of the PL/SQL block that you used for testing and its output and paste it in the same Word document as above.

Upload the Word document containing screenshot, your full name written at the top.

I have downloaded the file, but I am struggling with the Query builder .!!!! This is for Advanced DATA BASE class

Worksheet Query Builder 1 set serveroutput on 21 DECLARE 31v order total NUMBER (5,2) 4 BEGIN 5 tax calc('VA 100,lv order total) DBMS OUTPUT. PUT LINE (lv order total) 7 END Script Output x 4 Task completed in 0.015 seconds PL/SQL procedure successfully completed. 104.5