=== Samuel Sparenga === === Hunter | Drew === Function created. No errors. === TEST for salary $5000 (0) === PL/SQL procedure successfully completed. OVER_5000 ---------- 0 === TEST for salary $1500 (7) === PL/SQL procedure successfully completed. OVER_1500 ---------- 7 Function created. No errors. ============ TESTING get_manager Commit complete. 1 row created. ============ testing show_manager: should see Blake (as manager of Ward) PL/SQL procedure successfully completed. MANAGER_STRING -------------------------------------------------------------------------------- Blake ============ testing show_manager: should see King (as manager of Raimi) PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. MANAGER_STRING -------------------------------------------------------------------------------- King ============ testing show_manager: should see No manager (for King) PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. MANAGER_STRING -------------------------------------------------------------------------------- No manager ============ testing show_manager: should see Not an employee (for Wilbon) PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. MANAGER_STRING -------------------------------------------------------------------------------- Not an employee ============ testing show_manager: should see Name not unique (for Jones) PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. MANAGER_STRING -------------------------------------------------------------------------------- Name not unique Rollback complete. Procedure created. No errors. === TEST for job title Coder (0) === No available employees with that job titles PL/SQL procedure successfully completed. === TEST for job title Clerk (4) === Smith - managed by: Ford Adams - managed by: Scott James - managed by: Blake Miller - managed by: Raimi PL/SQL procedure successfully completed.