WRITE THE PL/SQL CODE TO CREATE PROCEDURE in the procedure using the Employees table find the average
Fantastic news! We've Found the answer you've been seeking!
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 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.
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: