Question: Assignment 11 1) Open SQL Developer then load the Schema_creation.sql and table population.sql scripts to create and populate the tables discussed in assignment I. Open

 Assignment 11 1) Open SQL Developer then load the Schema_creation.sql and

Assignment 11 1) Open SQL Developer then load the Schema_creation.sql and table population.sql scripts to create and populate the tables discussed in assignment I. Open a new SQL worksheet then write the PL/SQL code that creates the following objects. 2) Create in PL/SQL a stored procedure called 'Del_Details' to delete the record of orderedProduct table for which it receives as input the order number (orderNO) and the product number (productNO). [1.5] 3) Create in PL/SQL a stored Function called 'productPerOrder' to return the number of products placed for any order its number is given as input. [1.5] 4) Write a Trigger called changeCustomer_Category'. This trigger should be invoked before any update of customer balance in customer table. Its job is to modify the category of a customer from B2 to Bl and from C2 to C1 when a customer's balance status drops below a certain threshold (-10000).[2] 5) Save the script as assignment2_yourID then submit this file via Blackboard on or before

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