Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra and Trigonometry

Authors: Ron Larson

10th edition

9781337514255, 1337271179, 133751425X, 978-1337271172

More Books

Students also viewed these Databases questions

Question

Complete the following acid-base reactions: (a) HCCH + NaH

Answered: 1 week ago