Question: WRITE THE PL/SQL CODE TO CREATE PROCEDURE in the procedure using the Employees table find the average salary. Show it to the user. The procedure

WRITE THE PL/SQL CODE TO CREATE PROCEDURE

in the procedure using the Employees table find the average salary. Show it to the user. The procedure then calls another procedure that receives that average salary For those employees with a salary less than the average raise their salary by 10% For those employees with a salary greater than the average raise their salary by 1% In each case show the count of effective by the 10% raise and the 1% raise. Return from this called procedure to again Show the new average salary to the user.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

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

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Figure is an overhead view of a thin uniform rod of length 0.600 m and mass M rotating horizontally at 80.0 rad/s counterclockwise about an axis through its center. A particle of mass M/3.00 and...

The journal entries for Aubut Real Estate Agency Corporation were prepared in E3-9. Oct. 1 Issued common shares in exchange for $15,000 cash. 2 Hired an administrative assistant at an annual salary...

The probability distribution for damage claims paid by the Newton Automobile Insurance Company on collision insurance follows Payment ($) Probability 0 ............85 500 ............04 1000...

Is the faculty member a member of a professional organization? If so, which one(s)?

Gulf Coast Shrimp Company is a small company. It owns an icehouse and processing building, a refrigerated van, and three shrimp boats. Bob Jones inherited the company from his father three months...

Aly Services Incorporated (ASI) reports the following data each year: Net Operating Income: Average Operating Assets: Minimum Required Return: $22,200 $120,000 15.7% Requirement 1: Calculate ASI's...

The fish department of the local grocery store faces unique problems. Fish is extremely perishable and can only be sold on the day it arrives in the store. Fish is delivered at 3 am and can be sold...

11 . How, let's assume that the dividend growth reverts back to a L - I Sustainable growth rate = 6i'd after Year S to infinity . Estimate is Land !` ( 5 points )

A developer filed a breach of contract action against a general contractor in federal district court. If the contract was breached, the general contractor believes the fault was that of the framing...

What would be the approximate current flow in a 120 volt circuit with a 400 watt toaster and an 800 watt microwave oven attached

n Suppose X1,..., X are n iid random variables from the cumulative distribution func- tion F(x). Let Y = X; for i = 1,..., n. We further know that X; and Y; have the same distribution. For 0.5 Answered: 1 week ago

The following was posted 7:09 AM, MAY 4, 2020, by Fox Television Stations, updated AT 07:16AM, May 4, 2020. LITTLE ROCK, Ark. Walmart paid almost $180 million in cash bonuses to its hourly associates...

Typing your name at the end of an email typically constitutes an electronic signature under Queensland law. Provide an analysis and evaluation of the case law to date on whether an email header,...

i need this ASAP! please please pleaseee The December 31, 2021, post-closing trial balance for Strong Corporation is presented below: Prepare a classified balance sheet for Strong Corporation at...

The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...

Suppose you are the chief executive officer of a manufacturing firm that is bidding on a government contract. In this situation, the firm with the lowest bid will win the contract. Your firm has...

Define and explain the role of measures, objectives, and targets, in the Balanced Scorecard strategy map.

How does analysis of reasons for variances between actual and estimated costs help managers?

Nair A.G. enters into a contract with a customer to build an apartment building for 1,000,000. The customer hopes to rent apartments at the beginning of the school year and provides a performance...

Archer Construction Company began work on a $420,000 construction contract in 2019. During 2019, Archer incurred costs of $278,000, billed its customer for $215,000, and collected $175,000. At...

Ting Group began work on a 7,000,000 contract in 2019 to construct an office building. During 2019, Ting Group incurred costs of 1,700,000, billed its customers for 1,200,000, and collected 960,000....