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

Answers

Answer 1

Answer:

c

Explanation:

Answer 2

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


Related Questions

What is the difference between a computer’s RAM and its hard disk?
A. RAM is not volatile, which means that it is more reliable than a hard disk. A hard disk is volatile, which means that it is vulnerable to electronic interference.

B. RAM is volatile, which means that it does not retain information in memory after powering down. A hard is not volatile, which means that it retains information in memory after powering down.

C. RAM is not volatile, which means that it retains information in memory after powering down. A hard disk is also not volatile, which means that it retains information in memory after powering down.

D. RAM is volatile, which means that it must be handheld with care when removed or replaced. A hard disk is not volatile, which means that it is much more resistant to movement during removal or replacement.

Answers

Answer:

D. RAM is volatile, which means that it must be handheld with care when removed or replaced. A hard disk is not volatile, which means that it is much more resistant to movement during removal or replacement.

Explanation:

Most RAM (random access memory) used for primary storage in personal computers is volatile memory. Volatile memory contrasts with non-volatile memory, which does not lose content when power is lost. Non-volatile memory has a continuous source of power and does not need to have its memory content periodically refreshed.

Answer:

Explanation:

RAM can be accessed faster than hard drive. – Any changes made to the file will be present in RAM while once the changes are saved it is copied to the hard drive permanently. – RAM needs power to store data, hard drives do not.

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

Answers

Answer:

ANS is no.B and no. C

hope it helps

WORTH 75 POINTS!!
Which best describes the video encoding process?

converting analog video into digital video

filming a video at 30 frames per second

saving a digital video in a specific file format

watching a video while the file downloads

Answers

Answer:

To watch a digital video, you must use the codec that was used to encode the video file. Most videos are compressed.

Answer:

Why is compression important for video streaming?

to increase the number of frames per second so that motion appears smooth

to watch video without waiting for it to download(this one)

to improve image quality

to increase file size

Explanation:

F= A· (B+C). draw the symbol for the logic gate​

Answers

Answer:

You need an AND gate and an OR gate.

Explanation:

see picture below

What was the goal of the COMPETES Act of 2007?

Answers

Simply put, the goal was, "To invest in innovation through research and development, and to improve the competitiveness of the United States."

Answer:

Increasing federal investment in scientific research to improve U.S. economic competitiveness.

Explanation:

Hope this helps!

Ruzwana is a system administrator at an organization that has over 1000 employees. Each of the employees brings their own devices to work. She wants to find an efficient method that will allow her to make the various devices meet organizational standards. In addition, she would like to deploy various universal applications such as the VPN client, meeting software, and productivity software to these systems. Which of the following options should Ruzwana use to achieve the desired outcome in this scenario?
a. A provisioning package.
b. A catalog file.
c. A configuration set.
d. An answer filE.

Answers

In this scenario, the option which Ruzwana should use to ensure that the various devices meet organizational standards and for the deployment of various universal applications is: d. An answer file

An answer file can be defined as an XML-based file which contains the configuration settings and values that should be used during the installation of a software program on one or more devices in accordance with specific standards. Thus, each and every device using the same answer file would have the same configuration setting.

Additionally, an answer file allows a system administrator to automatically deploy various software programs such as meeting software and productivity software to a particular system or network.

In this context, the most appropriate option which Ruzwana should use to ensure that the various devices meet organizational standards and for the deployment of various universal applications is an answer file.

Read more on software here: https://brainly.com/question/25703767

Write a program that, given a file name typed by the user, reads the content of the file and determines the highest salary, lowest salary and average salary. The file contains employee records, and each record consists of the hours worked and the hourly rate. The salary is calculated as the product of the hours worked and the hourly rate.

An example of file containing three records is as follows:
10.5 25.0
40.0 30.0
30.9 26.5

Answers

Using the pandas packge in python, the program which performs the required calculation goes thus :

file_name = input()

#user types the filename

df = pd.read_csv(file_name, names=['hours_worked', 'rate']

#file is read into a pandas dataframe

df['salary'] = df['hours_worked'] * df['rate']

#salary column is created using the product of rate and hours worked

highest_salary = df['salary'].max()

#the max method returns the maximum value of a series

print('highest_salary)

lowest_salary = df['salary'].min()

#the min method returns the minimum value of a series

print('lowest_salary)

avg_salary = df['salary'].mean()

#the mean method returns the average value of a series

print('avg_salary)

Learn more : https://brainly.com/question/25677416

30th Nov 2020. Difference between Data and Information

Answers

Answer:

Data is a collection of unstructured or unorganized facts and figures.

Information is a collection of processed data.

Hope it helps...............

Consider the following class. public class ClassicClass { private static int count = 0; private int num; public ClassicClass() { count++; num = count; } public String toString() { return count + " " + num; } } What is printed when the following code in the main method of another class is run? ClassicClass a = new ClassicClass(); ClassicClass b = new ClassicClass(); ClassicClass c = new ClassicClass(); System.out.println(a + ", " + b + ", " + c);

Answers

The the code in the main method is run, it will print

"3 1, 3 2, 3 3"

The static/class field count stores the number of instances of the class created. count is always incremented when the instance constructor is called.

The instance field num acts like an identifier/serial number for the instance created. When the constructor is called, the current count is stored in the num field of the instance.

Each instance's toString( ) method will output the total count (from count) and the serial of the instance (from num).

When the code runs in the main method, it creates three instances (making count==3), so that we have

a = {count: 3, num: 1}b = {count: 3, num: 2}c = {count: 3, num: 3}

and implicitly calls toString( ) in the println method for each of the three instances to produce the following output

"3 1, 3 2, 3 3"

Learn more about programs here: https://brainly.com/question/22909010

In which wireless configuration type do nodes communicate directly with each other, rather than with an access point?
1)802.11b
2)Mesh network
3)Ad-hoc
4)2.4Ghz

Answers

Ad-hoc

Explanation:

In which wireless configuration type do nodes communicate directly with each other, rather than with an access point? In an AD-HOC network, all nodes communicate and transmit directly to each other.

Five jobs arrive nearly simultaneously for processing and their estimated CPU cycles are, respectively: Job A = 2 ms, Job B = 12 ms, Job C = 15 ms, Job D = 7 ms, and Job E = 3 ms.

Using FCFS, in what order would they be processed? What is the total time required to process all five jobs? What is the average turnaround time for each of these five jobs?

Answers

This is an example with solution:

Five jobs arrive nearly simultaneously for processing and their estimated CPU cycles are, respectively: Job A = 12, Job B = 2, Job C = 15, Job D = 7, and Job E = 3 ms.

a. Using FCFS, and assuming the difference in arrival time is negligible, in what order would they be processed? What is the total time required to process all five jobs? What is the average turnaround time for all five jobs?

Answer: The order of processing for the given jobs = A->B->C->D->E.

Total time needed to process all the jobs = 12+2+15+7+3 = 39 ms.

Turn around time for job A = 12 ms.

Turn around time for job B = 15 ms.

Turn around time for job C = 30 ms.

Turn around time for job D = 37 ms.

Turn around time for job E = 40 ms.

Answer : Therefore, the average turnaround time = (12+15+30+37+40)/5 = 26.8 ms.

Order of processing is A, B, C, D, E and Total time to process and Average turnaround time is 39 ms and 24 ms

Turnover time and order of processing:

Order of processing = A, B, C, D, E

Total time to process all five jobs = Job A + Job B + Job C + Job D + Job E

Total time to process all five jobs = 2 + 12 + 15 + 7 + 3

Total time to process all five jobs = 39 ms

Average turnaround time = [(2-0) + (2+12-0) + (2+12+15-0) + (2+12+15+7-0) + (2+12+15+7+3-0)] / 5

Average turnaround time = (2+14+29+36+39) / 5

Average turnaround time = 24 ms

Find out more information about 'Turnaround time'.

https://brainly.com/question/5768680?referrer=searchResults

50 free po.intssssssss!

Answers

Answer:ty

Explanation:

Ty tysm u angel u amazing human angel

the most important part of a computer​

Answers

Answer:

CPU central processing unit

What is the best data type for nationality field

Answers

Answer:

ISO Alpha-2 (two-letter country code) ISO Alpha-3 (three-letter country code) ISO Numeric (three-digit country code)

.tag is used to draw a horizontal line

Answers

Answer:

<hr>  tag.

Explanation:

<hr> tag makes a line along the webpage :)

A programmer will typically write a(n) _____ and pass it to the interpreter. Group of answer choices object method variable script

Answers

Answer:

Script

Explanation:

A set of code blocks which is written to solve a particular problem in a certain programming language and passed to the interpreter to run is called a script.

The script is program's body which is made up of codes written in accordance to the syntax of a certain programming language.

In other to execute the program written, it has to be passed to the interpreter, which run the script and produces an output.

Hence, the set of code written by a programmer is called the script.

Learn more :https://brainly.com/question/14364607

Why do some computer systems not allow users to activate macros?
O Amacro can be used by only one person.
0 You must close all other programs to run a macro.
O The Word software does not work well with macros.
O Macros can carry viruses that can harm a computer.

Answers

Macros can carry viruses that can harm a computer.

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%

Answers

1. Input
number_of_males = int(input('Enter the number of males: '))
number_of_females = int(input('Enter the number of females: '))

#2. Process
total_number_of_students = number_of_females + number_of_males
percentage_of_males = number_of_males / total_number_of_students
percentage_of_females = number_of_females / total_number_of_students

#3. Output
print('Total number of males =', format(percentage_of_males, '.0%'))
print('Total number of females =', format(percentage_of_females, '.0%'))

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

Answers

The array of String objects, use to count how many have a length less than

or equal to three is as follows:

string_object = ["brainly", "mathematics", "boy", "girl", "us", "joy", "key"]

x = []

for i in string_object:

   if len(i) <= 3:

       x.append(i)

print(len(x))

The code is written in python

The string array is declared.

Then an empty variable array is declared.

Then we loop through the array.

If any of the string length in the array is less than or equals to 3 , we append it to the empty array.

Then finally, we print the counted number of strings

learn more: https://brainly.com/question/22081416?referrer=searchResults

In the EXPLORE online library, the ratio of the number of novels to that of dictionaries is 2:3 and the total number of novels is 624. If Joe buys more novels and the ratio becomes 7:3, then how many novels have been bought in total?

Answers

Answer:

Answer is 2184

Explanation:

1st of all we need to know the total number of novels in the library if I have it with a ratio of one meaning:

2---------624

1----------???

(1×624)÷2 =312

Meaning with a ratio of 1 I'll have 312

Take the 312 and multiply with 7

It will give you 2184

That's the number of Novels which were bought by joe

Design a chip that can complete four bit binary addition, subtraction, and, or operation. Complete the Verilog program and show simulation on Modelsim software , write the program list and screenshot of simulation results.

Answers

Answer:

How am I supposed to design a chip here?

Explanation:

What are 3 things message timing must include

Answers

Answer:

1)Message Timing. Another factor that affects how well a message is received and understood is timing. ...

2)Access Method. Access method determines when someone is able to send a message. ...

3)Flow Control. Timing also affects how much information can be sent and the speed that it can be delivered.

1. Where did the Industrial Revolution start and why did it begin there?​

Answers

Answer:

The first Industrial Revolution began in Great Britain in the mid-to-late 1700s, when innovation led to goods being produced in large quantities due to machine manufacturing.

This process began in Britain in the 18th century and from there spread to other parts of the world. Although used earlier by French writers, the term Industrial Revolution was first popularized by the English economic historian Arnold Toynbee (1852–83) to describe Britain's economic development from 1760 to 1840.

Answer:

This process began in Britain in the 18th century and from there spread to other parts of the world. Although used earlier by French writers, the term Industrial Revolution was first popularized by the English economic historian Arnold Toynbee (1852–83) to describe Britain’s economic development from 1760 to 1840  

Historians have identified several reasons for why the Industrial Revolution began first in Britain, including: the effects of the Agricultural Revolution, large supplies of coal, geography of the country, a positive political climate, and a vast colonial empire.

Explanation:

HELP ME ILL GIVE BRAINLY Input 50 numbers and then output the average of the negative numbers only. Write in pseudocode!

Answers

Answer:

The explanation is for 10 inputs though. You'd have to follow these steps to find input 50 numbers.

Explanation:

This is how I wrote it in the Plain English programming language which looks like pseudo-code but compiles and runs (to save you all the rest of the steps):

To run:

Start up.

Write "Enter 10 numbers separated by spaces: " on the console.

Read a reply from the console.

Loop.

If the reply is blank, break.

Get a number from the reply.

Add 1 to a count.

Add the number to a total.

Repeat.

Write "The total is: " then the total on the console.

Put the total divided by the count into an average.

Write "The average is: " then the average on the console.

Refresh the screen.

Wait for the escape key.

Shut down.

Can someone help me explain Nvm scheduling in operating systems?

Answers

Low-power and short-latency memory access is critical to the performance of chip multiprocessor (CMP) system devices, especially to bridge the performance gap between memory and CPU

The system tray contains _____.
A. the battery life
B. the computer's hard drive
C. the operating system
D. Quick Launch

Answers

[tex]⇒[/tex]

the operating system

The notification area (also called the "system tray") is located in the Windows Taskbar, usually at the bottom right corner. It contains miniature icons for easy access to system functions such as antivirus settings, printer, modem, sound volume, battery status, and more.

Answer:

A BATTERY LIFEExplanation: The person said it and it was right I believed them, and they made me get a 100% thank you sir/madam and as you can see, I have proof so your welcome and thank you.

I Wouldn't just say the letter like A or C because everyone's quiz is different, and it changes but either way whatever your welcome and again thank you.

We can find out how robots work by looking in detail at the smaller parts. What do we call this?

Answers

Answer: This can be called the engineering.

Explanation:

Because the small parts is the bearings inside the robot

Tamanika got a raise in her hourly pay, from $15.90 to $17.65. Find the percent increase

Answers

15.90/17.65 = x/100
1590 = 17.65x
x = 90.08%
So this means the increase would be 9.92%

A large company pays its salespeople on a commission basis. The salespeople receive $900 per week, plus 8.75 percent of their gross sales for that week. For example, a salesperson who sells $10000 worth of merchandise in a week receives $900 plus 8.75 percent of $10000, or a total of $1775. You have been supplied with a list of the products sold by each salesperson. The values of these products are as follows:
Item Value
1 100
2 200
3 300
4 400
Develop a script that inputs one salesperson’s items sold for last week, calculates the salesperson’s earnings and outputs HTML5 text that displays the salesperson’s earnings.

Answers

Answer:

Explanation:

True or False. When FTP users authenticate with an FTP server, the sign-in process can be decoded by a protocol analyzer or network sniffer software.

Answers

The File Transfer Protocol is commonly called FTP. FTP users authenticate with an FTP server, the sign-in process can be decoded by a protocol analyzer or network sniffer software is a true statement.

There are some element that often specifies the authentication settings for FTP sites. The authentication settings are known to be wired or configured at only the site-level. They can also be configured per URL.

The File Transfer Protocol (FTP) is known simply as a standard communication protocol that is often employed for the movement of computer files from a server to a client using a computer network.

It uses the client–server model architecture via different control and data connections between the client and the server.

Learn more from

https://brainly.com/question/20602197

Other Questions
1aCCopper(II) nitrate decomposes on heating. The reaction is endothermic.2Cu(NO),(s) 2CuO(s) + 4NO2(g) + 0,(9)Sketch a reaction pathway diagram for this reaction to include theactivation energy[3]b Draw an energy cycle to calculate the standard enthalpy change forthis reaction, using enthalpy changes of formation.[3]Calculate the enthalpy change for this reaction using the followingenthalpy changes of formation.AH, [Cu(NO, ),(s)] = -302.9 kJ mol-'AH, [CuO(s)] =-157.3 kJ mol-!AH [NO,(g)] = +33.2 kJ mol-![3]d Copper(II) sulfate is soluble in water. A student dissolved 25.0 g ofcopper(II) sulfate in 100 cm of water in a polystyrene beaker stirringall the time. The temperature of the water fell by 2.9 C.i Calculate the enthalpy change of solution of copper(II) sulfate.(specific heat capacity of water = 4.18 Jg1 C ; relativemolecular mass of copper(II) sulfate = 249.7 g mol-')[3]ii Suggest one source of error in this experiment and explain howthe error affects the results.[2][Total: 14] 23. Multiple Choice Luis wants to make a deck that is similar to one that is 10 feetlong and 8 feet wide. Luis's deck must be 18 feet long. What must its width be?A 20 feetB 16 feetC 14.4 feet0 22.5 feet Note: Enter your answer and show all the steps that you use to solve this problem in the space provided. You buy clothing at a sale. You buy a sweater at 710 of its original price of $35. Answer each question and show all your work.a. How much money did you spend?b. How much money did you save?c. What fraction of the total original price did you save? This is the architectural plan for a fenced-in garden.The shaded region represents an area for trees.How long is the fence around the edge of the garden?(Do not include the edge around the tree region.) climate change is not the greatest threat to humanity What is alliteration?Question 2 options:Repetition of sounds at the beginning of wordsRepetition of sounds within wordsRepetition of only vowel soundsRepetition of only consonant sounds The nth term of a sequence is 3n2 - n + 10 where n is a positive integer. Which term in the sequence is equal to 54? I need the answer please and thank you Hi. can you help me? Chlorophyll aa. absorbs mostly orange-red andblue-violet light.b. absorbs mostly green light.c. is an accessory pigment.d. is responsible for the red color of manyautumn leaves. Which linear equation would produce a y-intercept of (0,-7) and a slope of 5? Megan rolls a ball down a ramp until the ball hits the wall. The vertices of a feasible region are (14, 2), (0, 9), (6, 8), and (10, 3). What is the maximum value of the objective function P if P = 180x 250y?. La caza de ballenas es un delito. Dnde se encuentra el ncleo del sujeto? In which situation may completion of an approved refresher course or 120 hours of continuing education most likely be required As part of a science experiment, Jose did a test for starch on a slice of apple and a slice of potato. The yellow-orange iodine solution stayed the same color when it was put on the apple, but it became black on the potato.Why did the iodine solution change color on the potato? A. The iodine burned the potato and turned it to ash. B. The iodine mixed with the colors of the potato so it looked black. C. The iodine evaporated into a gas. D. The iodine reacted with the potato to form a new substance. B. If the point are in line ( vertical) then it is not a functiom Question 2 (1 point)Technician A says Radial ply Tires are used for carrying a heavy Load. Technician B says that Bias Ply Tires are made with the Plies laid diagnally.Which Technician is correct? a)Technician A b)Technician B c)Both A & B d)Neither A dog has a litter of three male pups andfive female pups. What percent of the pupsin the litter are male? The cost of dance lessons is $12 for 1 lesson, $22 for 2 lessons, and $32 for 3 lessons. Use a graph to determine whether the cost is proportional to the number of lessons. Explain your reasoning.