Page 1 of 1
Assignment1 You will use the table oehr_employees already existing in the database MANAGER JO EMPLOYLUD PRST NAME LAST N
Posted: Sat Feb 19, 2022 3:22 pm
by 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 30 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.