Question: Write a complete PL / SQL block do the following. a . Input the price and quantity from keyboard for each item. b . Calculate

Write a complete PL/SQL block do the following.
a. Input the price and quantity from keyboard for each item.
b. Calculate the amount by multiplying the price by the quantity for each item.
c. Store the price, quantity, and amount inside the table for each item.
d. If the quantity is less than 50 : place "C" in the q_r_status field.
e. If the quantity between 50 and 100: place "B" in the q_r_status field.
f. If the quantity is more than 100 : place "A" in the q_r_status field.
g. Print the result on the screen.

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 Programming Questions!