Assignment1 You will use the table oehr_employees already existing in the database MANAGER JO EMPLOYLUD PRST NAME LAST N

[answerhappygod]

Assignment1 You Will Use The Table Oehr Employees Already Existing In The Database Manager Jo Employlud Prst Name Last N 1 (36.71 KiB) Viewed 28 times

Assignment1 You will use the table oehr_employees already existing in the database MANAGER JO EMPLOYLUD PRST NAME LAST NAME ting сомликлиот, кт DEPARTMENT_10 SALARY 24000 IMA PHONE_NUMBER SUSAS ROOMS SOS ABRUNOLD HIRE_DATE / 2011 уулond Gw2011 108.30 ABES ADW ADV OG TODO MOCO 1. Create a stored procedure named emp_lookup that returns the first name and the salary of an employee via empno. 2. In case of non-existing employee, the procedure will return: • 'NULL' for the employee name . -l for the salary. 3. Test the stored procedure emp_lookup for the case of existing and non-existing employee.