Question: Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is

Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the LINE_TOTAL amounts for the invoice, the INV_TAX is the product of the INV_SUBTOTAL and the tax rate (8%), and the INV_TOTAL is the sum of the INV_SUBTOTAL and the INV_TAX.

Step by Step Solution

★★★★★

3.43 Rating (175 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE OR REPLACE PROCEDURE PRCINVAMOUNTS WIN IN NUMBER AS WCHK NUMBER 0 WSUBT NUMBER 0 W... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

358-CS-DB (736).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Create a stored procedure named sp Balance Range that accepts three optional parameters. The procedure should return a result set consisting of Vendor Name, Invoice Number, and Balance for each...

Each day, workers at the Gotham City Police Department work two 6-hour shifts chosen from 12 A.M. to 6 A.M., 6 A.M. to 12 P.M., 12 P.M. to 6 P.M., and 6 P.M. to 12 A.M. The following number of...

Create a stored procedure named prc_new_rental to insert new rows in the RENTAL table. The procedure should satisfy the following conditions. a. The membership number will be provided as a parameter....

Hi, I am using MindTap on Cengage for my DAT 380 course. I need help with the following problems; Problem 31 Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE table...

31. Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE table every time you add a new LINE row. (The LINE_TOTAL value is the product of the LINE_UNITS and LINE_PRICE...

Create and submit a sql script to answer all the questions. Make sure to add comments in the document to add title for each question. Use Chapter 8 database script to create your database that you...

Create a Stored Procedure , for the SaleCo2 database, that will: Delete an Invoice from the Invoice table by accepting the Invoice # as a procedure parameter when you CALL the procedure to be...

Hey guys, I could use some help with a MySQL Stored Procedure problem. The problem is as follows: Create a Stored Procedure, for the SaleCo2 database, that will: Delete an Invoice from the Invoice...

Create and test a stored procedure called prc_inv_delete that takes an invoice number variable as a parameter and deletes the invoice number passed in to it from the table INVOICE. The code for this...

"Fortran, Algol and Lisp invented most programming language concepts 50 years ago; adding the concept of object-orientation suffices to explain all programming languages to date". To what extent is...

On December 1, Discount Electronics has three DVD players left in stock. All are identical; all are priced to sell at $85. One of the three DVD players left in stock, with serial #1012, was purchased...

Contrast the enzyme(s) present in the virions of a retrovirus and a positive-strand RNA bacteriophage. Why do they differ if each has plus configuration single-stranded RNA as its genome?

Which of the following statements regarding liabilities on the statement of financial position is CORRECT? I. They are categorized as fixed or variable. II . Any outstanding mortgage balance is...

How do purchasing-power parity, interest rate parity, and the International Fisher Effect explain the relationships between the current spot rate, the future spot rate, and the forward rate?

Write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental (result shown in FigureP7.92). Minimum Balance Maximum Balance Average Balance 15...

Write a query to display the rental number, rental date, video number, movie title, due date, and return date for all videos that were returned after the due date. Sort the results by rental number...

Write a query to display the rental number, rental date, video number, movie title, due date, return date, detail fee, and number of days past the due date that the video was returned for each video...

1.Create a table and derive the probability distribution for total dollar losses in this case. Note that this is total dollar losses, not number of losses. Make sure you label your table correctly. $...

Find the solution for the Question below Q. 7 The weather at a coastal resort is classified each day simply as "sunny" or "rainy." A sunny day is followed by another sunny day with probability 0.9,...

All answers must be entered as a formula. Click OK to begin. OK A stock has had the following year-end prices and dividends. What is the arithmetic return over this period? Year Price Dividend 59.32...