SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 314 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 05 Jan 2018 My Price 6.00

procedure that returns the most recent order

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.

 

Answers

SophiaPretty
(5)
Status NEW Posted 05 Jan 2018 11:01 AM My Price 6.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)