Develop procedure to returns recent order information

Assignment Help Programming Languages

Reference no: EM1367559

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

Questions Cloud

Asymmetric information exchange : In the value process, the estimation of the has historically been somewhat neglected in relation to the other steps in the process.

Describe return to an investment in a college education : Describe return to an investment in a college education. How would you go about measuring it. How would you decide it is good enough to warrant investment.

Pediatric nurses information on cardiac defects : By using the topic of teaching a core group of pediatric nurses information on cardiac defects and the care of post op cardiac patient, write down a goal statement, and develop and related objective staircase by using cognitive

What is the pucks speed as it goes over the top : A puck slides along the frictionless track shown in the figure with an initial speed of 7.40. Suppose the puck turns all corners smoothly, with no loss of speed.

Develop procedure to returns recent order information : Develop a procedure that returns the most recent order information for aparticular basket. This procedure must determine most recent stage entry from the BB_BASKETSTATUS table

Illustrate how increase in human capital affects production : Illustrate how increase in human capital affects production function. Blue line (circle symbols) in graph below shows production function.

What does the hanging scale read : A beaker of mass 1.5kg containing 3.2kg of water rests on a scale. A 3.2kg block of a metallic alloy of density 53400 kg/m is suspended from a spring scale is submerged in water of density 1000 kg/m.

Design program which models the worms behavior : Design a program which models the worms behavior in the following scenario: A worm is moving toward an apple. Each time it moves, the worm cuts the distance between itself and the apple.

Resolve the distance and direction from lake b : State the maximum height in terms of a, t_1, and/or g. Note that in this problem, g is a positive number equal to the magnitude of the acceleration due to gravity.

User Account

All Pages