Create a procedure named status_ship

Create a procedure named status_ship_sp

Assignment Help PL-SQL Programming

Reference no: EM131380430

Question: 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: EM131380430

Questions Cloud

How do nonverbal cues change a message : First, how do nonverbal cues change a message? How might you change your nonverbal cues to change the meaning of a message. When does that work? When doesn't it. Secondly, how does nonverbal communication work in romantic relationships? What nonve..

Create graphical displays for these two groups : MPG. A consumer organization compared gas mileage figures for several models of cars made in the United States with autos manufactured in other countries. The data are shown in the table.

How concepts you have gained in the given course : Discuss how the concepts and knowledge, along with standards and professional qualifications, you have gained in thiscourse relate to the following professional occupational positions.

Using appropriate diagrams of wage and price setting : Using appropriate diagrams of wage and price setting and aggregate demand and aggregate supply, explain and discuss the effects of an increase in the price of oil, assuming that this increase in price leads to an increase in the markup set by firms a..

Create a procedure named status_ship_sp : 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 location-specific advantages found in agglomeration : What are some of the location-specific advantages found in agglomeration, the clustering of economic activities in a concentrated area? What are the advantages and disadvantages for first movers? What are the advantages and disadvantages for late mov..

Which group had the greater interquartile range : If the mean reading level for boys was 4.2 and for girls was 4.6, what is the overall mean for the class?

What would you advise the importer to do : A US importer who owes and Belgian company 500,000 Euros payable in 30 days from today expects that the US Dollar will weaken during this period. What would you advise the importer to do? What would happen if the imported took your advice yet instead..

Should the law be able to punish this 52 year old man : Ex post facto laws are forbidden by the United States Constitution, and this protection prohibits the government from charging you with a crime using a law that was created after the crime was committed. If it was not a crime at the time an actor ..

User Account

All Pages