Q3.Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. Use an anonymous block to call the function and output the result.
PL/SQL Problems
Q1. Create a function to calculate a shopper’s total spending, excluding shipping and tax amount, with Brewbean’s site in a particular year. Exception handling is needed.
Use an anonymous block to call the function and output the result.
Q2.Create a procedure to allow an employee in the 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 current status, date, and comments as each stage of the order process are finished.
Use an anonymous block to test your procedure.
Q3.Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not.
Use an anonymous block to call the function and output the result.
Q4.Create a function to determine the total pledge amount for a project. Use the function in an SQL statement to list all projects, displaying project ID, project name, and project pledge total amount. Format the pledge total amount to show a dollar sign.
Add at least two rows in dd_pledge for the project “Covid-19 relief fund” which you created in assignment#2.
Q4. Create a procedure to allow company employee to add new product to the
Use an anonymous block to test your procedure.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
