Create procedure that returns most recent order information

Assignment Help Programming Languages

Reference no: EM1364933

Create a procedure that returns the most recent order information for aparticular basket. This procedure should determine the most recent stage entry from the BB_BASKETSTATUS table and return the data. An IF or CASE clause needs to be used to return the stage description rather than the IDSTAGE number, which means little to the shopper. The IDSTAGE column of the BB_BASKETSTATUS table identifies each stage as follows: 1 = Submitted and received; 2 = Confirmed, processed, sent to shipping; 3 = Shipped; 4 = Cancelled; 5 = Backordered. The procedure needs to accept a basket id number and return the most recent status description and the date that status was recorded. If no status is available for the basket id queried, return a message stating that no status is available. Use a VARCHAR2 host variable to hold the date value returned. Name the procedure STATUS_SP. Test the procedure twice using the basket id of 4 and then 6.

Reference no: EM1364933

Questions Cloud

Components of computer system interact within system : How do the components of your computer system interact within the system? What improvements or additions to your system do you think would benefit you or make the system more user-friendly? Why?

Future demands in the health information technology : Describe the essential knowledge, skills, and abilities that are necessary to meet the current and future demands in the Health Information Technology field.

What force does the water exert on the man : What force does the water exert on the man. explain how far does the tongue reach.

Compute the value of bonus : Suppose you received a $10,000 bonus which you would like to invest for your child's education. Compute the value of the bonus in 10-years if invested in each of the following:

Create procedure that returns most recent order information : Create a procedure that returns the most recent order information for aparticular basket. This procedure should determine the most recent stage entry

Managed care organization and its perspective : What are some of the ramifications of contract termination from a consumer's perspective, a provider's perspective, and a managed care perspective?

Accepting late bids : Should you reach out to potential contractors who haven't submitted bids regardless of the fact that they are late?

Why create a risk management plan : Describe the timeline as well as the economic and other factors involved with these risks - Why Create a Risk Management Plan

Calculating the new finance charge : A Department store has the following credit terms the finance charge. If any is based on the previous balance before payments or credits are deducted.

User Account

All Pages