1. Can tell me how to write a PL/SQL program to determine the lowest of three numbers by using Nested-If statement. The numbers will be assigned in the declare section. Question 2: [ 10 pts] - Stored Procedure Can tell me how to Write a PL/SQL procedure Insert_promo to insert a new row in the table oehr_promotions. The procedure should take in the promo_id and the promo_name as parameters. The procedure should not allow a duplicate value in the promo_name. To do so, you should: - check the non- existence of the new promotion to add. - Include exception handling - Notify the user about the status of the insertion (Success/failure) Can tell me how to Write an anonymous block to run the procedure for both scenarios (Success/failure) Question 3: - Functions Can tell me how to Write a PL/SQL function to increase the salary of a given employee. The program will search using the employee's ID and determine the new salary based on the job id: - AD_PRES: increase salary by 10% - AD_VP: increase salary by 8% - IT_Prog : increase salary by 15% - Any other class: Nothing Your program should store the result into a variable. Include exception handling Run the program hardcoding in a search for the employee id 110. **Hint: Use OEHR_EMPLOYEES table.

Answer rating: 100% (QA)

Question 1 Lowest of Three Numbers using NestedIf Statement in PLSQL sql Copy DECLARE num1 NUMBER 10 num2 NUMBER 5 num3 NUMBER 8 lowest NUMBER BEGIN I... View the full answer