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 PLSQL 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 : place C in the qrstatus field.
e If the quantity between and : place B in the qrstatus field.
f If the quantity is more than : place A in the qrstatus 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
