Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Heres a PLSQL function that increases the salary of a given employee based on th... View full answer

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!

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...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...

Objective: The purpose of the program is to: 1. Write functions to read in and print an Employee struct 2. Write an additional function that passes in an array of Employees and returns the index to a...

Part 1 - For this assignment, students will once again be working with the hypothetical, growing, start-up organization that was developed in the Total Rewards: Compensation course. A review of the...

Overview: RA 4 builds on your chapter readings on performance evaluation, managing compensation, and pay for performance. You may choose the format to use, however, all responses must be numbered as...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

Using this table: CREATE TABLE department ( DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) NOT NULL UNIQUE, LOCATION VARCHAR2(20) NOT NULL); INSERT INTO department VALUES(10,...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Johannes CC Balance sheet extracts for the year ended 3 1 March 2 0 1 8 \ table [ [ Balance sheet extracts for the year ended 3 1 March 2 0 1 8 , ] , [ Fixed Assets,N$ 1 2 0 0 0 0 0 ] , [ Current...

an 1800 kg vehicle travelling at 60.0km/h smashes into a concrete barrier and stops in 0.420s what is the magnitude of the collision force on the vehicle

Flo's Deli is determining how to ensure that their current process of serving customers during lunch rush is adequate. Which of the following is an example of how the restaurant can monitor its...

In an agile lifecycle, who should be involved in all overlapping sprints or releases? Select an answer: everyone on the product team the product manager only You should not overlap sprints or...

According to the concept of "position/legitimate power," the CEO has the ultimate responsibility for leading the tasks of forming, implementing, and executing a strategic plan for the whole...

Which of the following considerations is legally in sufficient? Tony bought a book for $100. Ruby offers to buy it for $10. Tony bought a text book for $100. He offers to give it to Ruby if Ruby...

12.95 244 8.08 1422 7 7.105.54 62424 1001 no 41 487 579 264 12.90 21 11 361 15.00 241 2100 2015 or 47878 Central 477407 South 430137 Central 478406 Central 479529 Central 479471 Central 479565...

Thalina Mineral Works is one of the worlds leading producers of cultured pearls. The companys condensed statement of cash flows for the years 20182020 follows. Required Comment on Thalina Mineral...

Determine the place value of the number 4 in each decimal. 1. 23.45 2. 0.000345

In a survey of 2000 people, it was found that 1320 have a microwave oven. Find the percent of people who own microwaves.

Write each decimal in standard form. 1. Eight and six hundredths 2. Negative five hundred three and one hundred two Thousandths Write each decimal in standard form. 3. Sixteen thousand twenty-five...

1. In the English language, the letter t has no meaning out of context. Its meaning depends on its relationship to other letters. Indeed, even a word, such as to, has little meaning except in its...

7. What is the function of Golgi tendon organs?

11. Explain the evidence that someones conscious decision to move does not cause the movement.