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

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

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!