Question: a) Given the EMPLOYEES table structure as follows: PRIMARY KEY Yes COLUMN NAME DATA TYPE EMPLOYEE_ID NUMBER(6,0) FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(25) SALARY NUMBER(8,2) MANAGER_ID NUMBER(6,0)

a) Given the EMPLOYEES table structure as follows: PRIMARY KEY Yes COLUMN NAME DATA TYPE EMPLOYEE_ID NUMBER(6,0) FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(25) SALARY NUMBER(8,2) MANAGER_ID NUMBER(6,0) NULLABLE No Yes No No Yes Create a procedure called NEW_SALARY that accepts an employee id and returns salary and new salary with a 15% increase to the calling environment. Invoke the procedure from a PL/SQL block by supplying 118 for the employee id. Print the salary and new salary. (10 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
