Create a procedure, Create a procedure named STATUS_SHIP

Create a procedure

Assignment Help PL-SQL Programming

Reference no: EM131380419

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTATUS table maintains a list of events for each order so that a shopper can see the current status, date, and comments as each stage of the order process is completed. The IDSTAGE column of the BB_BASKETSTATUS table identifies each stage and an IDSTAGE of 3 indicates the order has been shipped.

The procedure should allow the addition of a row indicating an IDSTAGE of 3, date shipped, tracking number, and shipper. The sequence BB_STATUS_SEQ is used to provide a value for the primary key column. Test the procedure with the following information:

Basket # = 3

Date Shipped = 20-FEB-03

Shipper = UPS

Tracking # = ZW2384YXK4957

Reference no: EM131380419

Questions Cloud

What price should publisher charge bookstore : If the bookstore charges double what it pays the publisher, what price should the publisher charge the bookstore for each version of the book?

Which equation best represents the taylor rule : Which equation best represents the Taylor rule?

What are some benefits of the benefits-cost ratio : What are some benefits of the Benefits-Cost Ratio? What are some disadvantages of the Benefits-Cost Ratio? What are some depreciation methods? What are the more common methods used in the United States? What does depreciation mean?

Methods be used to maximize your companys profits : Suppose your company sells four products and during a year a customer will buy each product at most once.- How can the methods be used to maximize your company's profits?

Create a procedure : Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTATUS table maintains a list of events for each order so that a shoppe..

What is the new standard deviation : Car speeds again. For the car speed data of Exercise 18, recall that the mean speed recorded was 23.84 mph, with a standard deviation of 3.56 mph. To see how many cars are speeding, John subtracts 20 mph from all speeds.

Find a profit maximizing a two part tariff : It costs you $5 in variable costs to provide a customer with a round of golf. Find a profit maximizing a two-part tariff. Each market segment is of equal size.

Calculate the fed inflation target from information : Suppose the federal funds rate is 4.4 percent and you know that the Fed is following the Taylor rule. You don't know the Fed's inflation target, but the equilibrium real interest rate is 4 percent, the inflation rate is 3 percent, the weight on the G..

Explain the concept of risk-based corrective action : What should prospective buyers of commercial property do tin order to protect themselves from liability under CERCLA? Explain the concept of Risk-Based Corrective Action (RCBA).

User Account

All Pages