SQL> @ 328lect05-1

Procedure created.

No errors.

============
TESTING job_overview

============
testing job_overview:
should see output including President, 1, and $5000:
============
Job Title : President                                                           
# with Job: 1                                                                   
Avg Salary: $5000                                                               

PL/SQL procedure successfully completed.

============
testing job_overview:
should see output including Sales, 4, and $1400:
============
Job Title : Sales                                                               
# with Job: 4                                                                   
Avg Salary: $1400                                                               

PL/SQL procedure successfully completed.

============
testing job_overview:
should see output including Kitten Wranger, 0, and $0:
============
Job Title : Kitten Wrangler                                                     
# with Job: 0                                                                   
Avg Salary: $0                                                                  

PL/SQL procedure successfully completed.


Function created.

No errors.

============
TESTING job_count


PL/SQL procedure successfully completed.

============
testing job_count: should see 1

   NUM_JOB                                                                      
----------                                                                      
         1                                                                      


PL/SQL procedure successfully completed.

============
testing job_count: should see 4

   NUM_JOB                                                                      
----------                                                                      
         4                                                                      


PL/SQL procedure successfully completed.

============
testing job_count: should see 0

   NUM_JOB                                                                      
----------                                                                      
         0                                                                      

SQL> spool off