SQL> @ 328lect05-1

Function created.

No errors.

========
testing job_count
========

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

should be 1:

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


PL/SQL procedure successfully completed.

should be 4:

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


PL/SQL procedure successfully completed.

should be 0:

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


Procedure created.

No errors.

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

PL/SQL procedure successfully completed.

should see: Sales, 4, $1400:
========
Job Title : Sales                                                               
# with Job: 4                                                                   
Avg Salary: $1400                                                               

PL/SQL procedure successfully completed.

should see: Kitten Wrangler, 0, and $0:
========
Job Title : Kitten Wrangler                                                     
# with Job: 0                                                                   
Avg Salary: $0                                                                  

PL/SQL procedure successfully completed.

SQL> spool off