Question: Q 1 . Use SH . PRODUCTS Create a table Assignment _ Products table using SH . Products. Use a procedure and implement bulk insert
Q Use SHPRODUCTS Create a table AssignmentProducts table using SH Products. Use a procedure and implement bulk insert to populated the AssignmentProducts table Use a function to update the column ProdMinprice and increment the values by dollars. Write another PLSQL procedure that updates the 'PRODSTATUS' column in the 'PRODCATEGORY', setting their status to 'Inactive' if their 'PRODLISTPRICE' is below a Provide detailed comments explaining the logic and flow of your PLSQL code.
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
