Question: PL/SQL Question using brewbeans database chapter 5 Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the

PL/SQL Question using brewbeans database chapter 5

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

N PL/SQL In your assignment file that you submit, first, place the code needed to create the procedure. After that, skip a few lines and there include the anonymous block code to call the procedure....

Assignment 2 (Due is April 20 th ) Question 1 Identifying Customers Assignment 2 (Due is April 20th) Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free...

these are the querys CREATE OR REPLACE FUNCTION status_desc_sf (p_stage IN NUMBER) RETURN VARCHAR2 IS lv_stage_txt VARCHAR2(30); BEGIN IF p_stage = 1 THEN lv_stage_txt := 'Order Submitted'; ELSIF...

Oracle 11g PL/SQL question. The tables needed can be created with the c10_BBcreate.sql listed below. Using Dynamic SQL to create a procedure named add_row_sp for inserting a row into a table with...

sql database Assignment 2 (Due is April 20th) Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free shipping to customers who havent returned to the site since...

DROP VIEW bb_basketitem_vu; DROP VIEW bb_ship_vu; DROP TABLE bb_department CASCADE CONSTRAINTS; DROP TABLE bb_product CASCADE CONSTRAINTS; DROP TABLE bb_productoption CASCADE CONSTRAINTS; DROP TABLE...

Course Description Human Resource Management provides a management-oriented exploration of human resource management, structure, functional applications, and labor management relations. Focus is...

In your assignment file that you submit, first, place the code needed to create the procedure. After that, skip a few lines and there include the anonymous block code to call the procedure. For this...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Instructions. HW 3 Attached Files: 1S_3063_HW3.xlsx (16.482 KB) HW 3 allows you to implement the data models we learned so far to an actual database. Please review the two lectures for Chapter 4...

6. A bowl of soup at 160 F is placed into a room with a temperature of 82 F. After one hour, the temperature of the soup is 110 F. a) Find a formula for the temperature of the soup, T( t ). b) Find...

Compute the collimation correction factor C for the following field data, taken in accordance with the example and sketch in the field notes of Figure 19.18. With the instrument at station 1, high,...

The cost benefit analysis is calculated over 12 months. You must provide calculations and figures for each of the resources that related from the budget in scenario Following this Cost IT Resource:...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

to encourage a drive for change by developing new ideas;

4 What are the alternatives to the competences approach?

2 What different concepts and approaches are used in countries with dissimilar cultures?