Question: Q 1 . Use SH . PRODUCTS Create a table Assignment _ Products table using SH . Products. Use a procedure and implement bulk insert

Q1. Use SH.PRODUCTS Create a table Assignment_Products table using SH. Products. Use a procedure and implement bulk insert to populated the Assignment_Products table Use a function to update the column Prod_Min_price and increment the values by 200 dollars. Write another PL/SQL procedure that updates the 'PROD_STATUS' column in the 'PROD_CATEGORY', setting their status to 'Inactive' if their 'PROD_LIST_PRICE' is below a 50. Provide detailed comments explaining the logic and flow of your PL/SQL code.

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!