Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started