SQL> @ 328lect05-2
Procedure created.
No errors.
============
TESTING job_overview
============
testing job_overview('President'):
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('Sales'):
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('Kitten Wrangler'):
should see output including Kitten Wranger, 0, and $0:
============
Job Title : Kitten Wrangler
# with Job: 0
Avg Salary: $0
PL/SQL procedure successfully completed.
Procedure created.
No errors.
============
TESTING loopy
============
testing loopy(5):
should see:
======
BURP! followed by 0-4,
GLIP! followed by 13-16,
all department names and locations,
a message that King has a salary 1000 times 5,
then i has value: followed by 100-103
============
BURP! 0
BURP! 1
BURP! 2
BURP! 3
BURP! 4
GLIP! 13
GLIP! 14
GLIP! 15
GLIP! 16
Accounting is in New York
Chocolate is in Arcata
Management is in New York
Operations is in Boston
Research is in Dallas
Sales is in Chicago
Look! King has salary that is 1000 times 5
i has value: 100
i has value: 101
i has value: 102
i has value: 103
PL/SQL procedure successfully completed.
============
testing loopy(2):
should see:
======
BURP! followed by 0-1,
GLIP! followed by 13-16,
all department names and locations,
a message that no employee has a salary 1000 times 2
(i loop is never reached because exception raised)
============
BURP! 0
BURP! 1
GLIP! 13
GLIP! 14
GLIP! 15
GLIP! 16
Accounting is in New York
Chocolate is in Arcata
Management is in New York
Operations is in Boston
Research is in Dallas
Sales is in Chicago
No employee has salary 2000
PL/SQL procedure successfully completed.
============
testing loopy(1.25):
should see:
======
BURP! followed by 0-1,
GLIP! followed by 13-16,
all department names and locations,
messages that Ward and Martin have a salary 1000 times 1.25
(i loop is never reached because exception raised)
============
BURP! 0
BURP! 1
GLIP! 13
GLIP! 14
GLIP! 15
GLIP! 16
Accounting is in New York
Chocolate is in Arcata
Management is in New York
Operations is in Boston
Research is in Dallas
Sales is in Chicago
Look! Ward has salary that is 1000 times 1.25
Look! Martin has salary that is 1000 times 1.25
PL/SQL procedure successfully completed.
Procedure created.
No errors.
============
TESTING reverse_play
============
testing reverse_play():
should see i from 2 to 5,
j from 5 to 2,
and that is all:
============
i: 2
i: 3
i: 4
i: 5
j: 5
j: 4
j: 3
j: 2
PL/SQL procedure successfully completed.
SQL> spool off