Oracle PL/SQL

Exercise 3 1. Create the table employee as follow: empno ename job mgr hiredate sal comm deptno Column name Data type date number(7, 2) number(7, 2) number(2) number(4) varchar2(10) varchar2(9) number(4) not null 2. Insert four rows to the preceding table. 3. Create a stored procedure named emp_lookup that returns the name and the salary of an employee empno. emp_lookup will return a value of 'NULL' for the employee name and a value of -1 for the salary in case of non-existing employee. 4. Test the stored procedure emp_lookup for the case of existing and non-existing employee