Question: Create a procedure or funciton Raise _ Empsal to increase 1 5 % salary for a specific employee . Hint: when invoked Raise _ Empsal,

Create a procedure or funciton Raise_Empsal to increase 15% salary for a specific employee .
Hint: when invoked Raise_Empsal, it should accept the parameter for empno, and update the employee record with a salary increase of 15%.
-- Use emp table , and make appropriate assumptions if you need to.
-- Invoke or test the procedure/function

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!