How to write a PL/SQL function to increase the salary of a given employee? The program will search using the employee's ID and determine the new salary based on the job id: - AD_PRES: increase salary by 10% - AD_VP: increase salary by 8% - IT_Prog : increase salary by 15% - Any other class: Nothing Your program should store the result into a variable. Include exception handling Run the program hardcoding in a search for the employee id 110. 

Answer rating: 100% (QA)

Heres a PLSQL function that increases the salary of a given employee based on th... View the full answer