Create a procedure named STATUS_SHIP_SP that allows an employee in the Brewbeans' Shipping Department to update an order status to add shipping information. The BB_BASKETSTATUS table lists events for each order so that a shopper can see the status, date, and comments as each stage of the order process is finished. The IDSTAGE column of the BB_BASKETSTATUS table identifies each stage; the value 3 in this column indicates that an order has been shipped. The procedure should allow adding a row with an IDSTAGE of 3, date shipped, tracking number and shipper. The BB_STATUS_SEQ sequence is used to provide a value for the primary key column. Test the procedure with the following information: o Basket # = 3 o Date shipped = 20-FEB-12 o Shipper = UPS o Tracking # = ZW2384YXK4957

Answer:

c

Explanation:

A procedure named STATUS_SHIP_SP that allows an employee in the Brewbeans' Shipping Department to update an order status to add shipping information is in the explanation part below.

A representative from Brewbeans' shipping division can change an order's status and add shipment details by using the PL/SQL method STATUS_SHIP_SP, as shown in the following example:

CREATE OR REPLACE PROCEDURE STATUS_SHIP_SP (

   p_basket_number   IN  NUMBER,

   p_date_shipped    IN  DATE,

   p_shipper         IN  VARCHAR2,

   p_tracking_number IN  VARCHAR2

)

IS

   v_status_id   NUMBER;

BEGIN

   -- Get the next value from the BB_STATUS_SEQ sequence

   SELECT BB_STATUS_SEQ.NEXTVAL INTO v_status_id FROM DUAL;

   -- Insert a new row into the BB_BASKETSTATUS table

   INSERT INTO BB_BASKETSTATUS (STATUSID, BASKETNO, IDSTAGE, STATUSDATE, COMMENTS)

   VALUES (v_status_id, p_basket_number, 3, p_date_shipped, 'Shipped: ' || p_shipper || ', Tracking Number: ' || p_tracking_number);

   -- Commit the transaction

   COMMIT;

   -- Display a success message

   DBMS_OUTPUT.PUT_LINE('Order status updated. Shipment information added.');

EXCEPTION

   WHEN OTHERS THEN

       -- Display an error message

       DBMS_OUTPUT.PUT_LINE('Error: Unable to update order status.');

       -- Rollback the transaction

       ROLLBACK;

END;

/

Thus, by doing this, the procedure will be called with the specified parameters, and if successful, a new entry with the proper shipping information for basket number 3 will be added to the BB_BASKETSTATUS database.

For more details regarding SQL, visit:

https://brainly.com/question/34315524

#SPJ6

An engine that generates hot, expanding gases by burning fuel inside the machine.

what is the different sheets in excel

If ClassC is derived from ClassB which is derived from ClassA, this would be an example of ________.

Create a program that asks the user for the number of male and female students registered in a class/section. The program should display the total number of students and the percentage of male and female in the class.

Sample output
Enter the number of male: 36
Enter the number of female: 17
Number of students = 53
Male = 67.92%
Female = 32.08%

Queries are questions true or false?

What is a storage device? Give one example of Primary magnetic storage, Primary optical storage and Portable storage.

If you were a hackathon team manager, how could you best address the conflict created by having more volunteers than open roles

Which two are computing devices? (Choose two)
A. Unix
B. Laptop
C. Server
D. Mac OS

What are the three algorithm constructs?

Differentiate between patent and copyright.

What are two drawbacks of using netbook ? (Choose two)
A. Portability
B. Screen size
C. Boot up time
D. Storage capacity

Given an array of String objects, use streams to count how many have a length less than or equal to three. StringLengthDemo.java

You modified the GreenvilleRevenue program to include a number of methods. Now modify every data entry statement to use a TryParse() method to ensure that each piece of data is the correct type. Any invalid user entries should generate an appropriate message, and the user should be required to reenter the data.
using System;
using static System.Console;
class GreenvilleRevenue
{
static void Main(string[] args)
{
const int fee = 25;
int lastYearsContestants;
int thisYearsContestants;
const int LOW = 0;
const int HIGH = 30;
int other = 0;
int dancer = 0;
int musician = 0;
int singer = 0;
WriteLine("**********************************");
WriteLine("* The stars shine in Greenville. *");
WriteLine("**********************************");
WriteLine("");
lastYearsContestants = getContestantsNum(message, LOW, HIGH);
string[] contestant = new string[thisYearsContestants];
string[] talent = new string[thisYearsContestants];
getContestantsInfo(contestant, talent);
for (int x = 0; x < talent.Length; ++x)
{
if (talent[x] == "O")
{
++other;
}
else if (talent[x] == "S")
{
++singer;
}
else if (talent[x] == "D")
{
++dancer;
}
else if (talent[x] == "M")
{
++musician;
}
}
Clear();
WriteLine("Currently signed up, there are..");
WriteLine("{0} dancers", dancer);
WriteLine("{0} singers", singer);
WriteLine("{0} musicians", musician);
WriteLine("{0} everything else!", other);
contestantByTalent(contestant, talent);
Clear();
contestantInfo(thisYearsContestants, lastYearsContestants, fee);
}
static int getContestantsNum(string message, int LOW, int HIGH)
{
WriteLine("Please enter the number of contestants for last year.>>");
string input = ReadLine();
int contestantsNum = Convert.ToInt32(input);
while (contestantsNum < LOW || contestantsNum > HIGH)
{
WriteLine("Valid numbers are 0 through 30, Please try again.>>");
contestantsNum = Convert.ToInt32(ReadLine());
}
return contestantsNum;
WriteLine("Please enter the number of contestants for this year.>>");
string input = ReadLine();
int contestantsNum = Convert.ToInt32(input);
while (contestantsNum < LOW || contestantsNum > HIGH)
{
WriteLine("Valid numbers are 0 through 30, Please try again.>>");
contestantsNum = Convert.ToInt32(ReadLine());
}
return contestantsNum;
}
static string getTalent(int contestantsNum)
{
bool correct = false;
string talentType = "";
while (!correct)
{
WriteLine("What is contestant " + contestantsNum + "'s skill? Please enter 'S' for Singer, 'D' for Dancer, 'M' for " +
"Musician, 'O' for Other.>>");
talentType = ReadLine().ToUpper();
if (talentType == "S" || talentType == "D" || talentType == "M" || talentType == "O")
{
correct = true;
}
else
{
WriteLine("Please enter a valid response.>>");
}
}
return talentType;
}
static void contestantByTalent(string[] contestant, string[] talent)
{
WriteLine ("To see a list of all contestants with a specific talent, Please enter a talent code.talent codes are(S)inger, (D)ancer, (M)usician, (O)ther; altenatively, you may type (E) to exit.>>");
string entry = ReadLine().ToUpper();
while (entry != "E")
{
if (entry != "S" && entry != "D" && entry != "M" && entry != "O")
{
WriteLine("That wasn't a valid talent code. Valid talent codes are (S)inger, (D)ancer, (M)usician, (O)ther; altenatively, you may type (E) to exit.>>");
entry = ReadLine().ToUpper();
if (entry == "E")
break;
}
for (int x = 0; x < talent.Length; ++x)
{
if (entry == talent[x])
WriteLine("Contestant " + contestant[x] + " talent " + talent[x]);
}
WriteLine("To see a list of all contestants with a specific talent, Please enter a talent code. talent codes are (S)inger, (D)ancer, (M)usician, (O)ther; altenatively, you may type (E) to exit.>>");
entry = ReadLine().ToUpper();
}
}
static void getContestantsInfo(string[] contestant, string[] talent)
{
for (int x = 0; x < contestant.Length; ++x)
{
WriteLine("What is the name for Contestant " + (x + 1) + "?");
contestant[x] = ReadLine();
talent[x] = getTalent(x + 1);
}
}
static void contestantInfo (int thisYearsContestants, int lastYearsContestants, int fee)
{
if (thisYearsContestants > lastYearsContestants * 2)
{
WriteLine("The competition is more than twice as big this year!");
WriteLine("The expected revenue for this year's competition is {0:C}", (thisYearsContestants * fee));
}
else
if (thisYearsContestants > lastYearsContestants && thisYearsContestants <= (lastYearsContestants * 2))
{
WriteLine("The competition is bigger than ever!");
WriteLine("The expected revenue for this year's competition is {0:C}", (thisYearsContestants * fee));
}
else
if (thisYearsContestants < lastYearsContestants)
{
WriteLine("A tighter race this year! Come out and cast your vote!");
WriteLine("The expected revenue for this year's competition is {0:C}.", (thisYearsContestants * fee));
}
}
}

What symbol must go at the end of an if statement?

please help!!!! what is the meaning of M,I,C,R,O,S,O,F,T word?
M-
I-
C-
R-
O-
S-
O-
F-
T-​

Which of the following is NOT a function of a Web Browser?
O Provide a platform that users can use to access web pages and sites
O Access a Web server and request a page on the Internet so the right information shows up
O Crawl through the World Wide Web searching for words and terms to index in Web Databases
O Interpret Web page's HTML tags and display the Web page's information in a way that is intended/easily readable for you

Please help me !!!!!!!

Imagine you were going to use a dedicated workstation for an animation job rather than a personal PC. What differences would you expect to see between a dedicated 3D animation workstation and a typical PC

Write javascript code for the form that appears in the image below. you are expected to add validation to the name field, email field, and radio button selection. The HTML code is given below, Insert the javascript validation code in the area of the HTML code shown below and save the file. Paste one screenshot of the validation you have written.

Couldn't find much on this, and don't rly know what to do.

How does tracking changes relate to sharing a workbook in Excel?

What was the goal of the COMPETES Act of 2007?

1. Fill in the blanks with appropriate word. 5°1-5 is a collection of raw unprocessed facts, figures, and symbols ​

A machine that converts energy to useful work.

Can someone pass me Unit 2 Basic Animations from CMU CS ACADEMY, I'll pay you if you pass it to me.

What type of rules specify user privileges to select, insert, update, and delete data for different tables and views

a leading global vendor Of computer software hardware for computer mobile and gaming systems and cloud services it's corporate headquarters is located in Redmond Washington and it has offices in more then 60 countries

Which One Is It

A) Apple
B) Microsoft
C) IBM
D) Global Impact​

You arrive at your first client meeting with Jaba's Smoothie Hut. Jaba's owner, Kim, has asked you to install a Wi-Fi network for his customers. Kim has told you that the store needs the following:

Dedicated internet service with enough bandwidth to meet customer demand and run the store.
Be cost effective (Kim does not want the most expensive or the cheapest).
Customers will use Wi-Fi and the business will have 5 wired connections

Select the correct package for the Jaba's Smoothie Hut:

a. 20 Mbps service with 1 modem/Router, a 16 port switch, and 1 wireless access point
b. 100 Mbps service with 1 Modem/Router, a 24 port switch, 3 wireless access points (1 for office, 1 for retail, and 1 for outside)

Consider the conditions and intentions behind the creation of the internet—that it was initially created as a tool for academics and federal problem-solvers. How might that explain some of the security vulnerabilities present in the “cloud” today?

Your company is building a new architecture to support its data-centric business focus. You are responsible for setting up the network. Your company's mobile and web-facing applications will be deployed on-premises, and all data analysis will be conducted in GCP. The plan is to process and load 7 years of archived .csv files totaling 900 TB of data and then continue loading 10 TB of data daily. You currently have an existing 100-MB internet connection. What actions will meet your company's needs

Discuss some of the reasons you feel that people have for either liking or disliking Excel