Create a procedure that allows employee to update the status

Assignment Help PL-SQL Programming

Reference no: EM131435980

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: EM131435980

Questions Cloud

Project plan that has received approval from all parties : Mass production automobile manufacturing does not qualify as a project because: What do we call the final form of the project plan that has received approval from all parties involved?

What fasb covers the reporting and accounting of goodwill : What FASB covers the reporting and accounting of goodwill? What is the difference between old goodwill reporting and new goodwill reporting?

What is its initial speed : What is its initial speed? What is the total time in the air before it hits the ground? At what angle and speed will the baseball hit the ground?

Is there any evidence to refute the manufacturers claim : The sample standard deviation in fracture stress was s = 21.56. Is there any evidence to refute the manufacturer's claim? Assume the underlying distribution is normal and use a = 0.01.

Create a procedure that allows employee to update the status : 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

Discuss about the neuroscience investigation : you will finalize your grant proposal to secure funding for a neuroscience investigation. This assignment will involve integrating information covered in previous weeks about brain networks and disorders that occur as the result of dysfunction in ..

Field at the center of solenoid : Consider a SlinkyTM arranged with 175 turns per meter. What current would be required to make a 0.500 mT field at the center of this solenoid?

Suggest proportion of students participating in programs : In a random sample of 1200 graduating college students, 150 said they had participated in a study-abroad program. Is there any evidence to suggest the proportion of students participating in these programs has decreased? Use a = 0.05.

Find the p value associated with given hypothesis test : Is there any evidence to suggest the proportion of tractor batteries that last at least three years is less than 0.95? Use a = 0.05.

User Account

All Pages