+-+-+-+-+-+-+-+-+-+
By Drew Hengehold
+-+-+-+-+-+-+-+-+-+

Procedure created.

No errors.
========Testing silly_shout========

+-+-+-+-+-+-+-+-+-+
(Test 1 silly_shout) Should output: HOWDY!! 5 times
+-+-+-+-+-+-+-+-+-+
HOWDY!!                                                                                                                                                                                                                                                                                                                                                       
HOWDY!!                                                                                                                                                                                                                                                                                                                                                       
HOWDY!!                                                                                                                                                                                                                                                                                                                                                       
HOWDY!!                                                                                                                                                                                                                                                                                                                                                       
HOWDY!!                                                                                                                                                                                                                                                                                                                                                       

PL/SQL procedure successfully completed.

+-+-+-+-+-+-+-+-+-+
(Test 2 silly_shout) Should output: WHY!! 2 times
+-+-+-+-+-+-+-+-+-+
WHY!!                                                                                                                                                                                                                                                                                                                                                         
WHY!!                                                                                                                                                                                                                                                                                                                                                         

PL/SQL procedure successfully completed.

+-+-+-+-+-+-+-+-+-+
(Test 3 silly_shout) Should output: Nothing
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.

+-+-+-+-+-+-+-+-+-+
(Test 4 silly_shout) Should output: Cannot show me -2 times
+-+-+-+-+-+-+-+-+-+
Cannot show me -2 times                                                                                                                                                                                                                                                                                                                                       

PL/SQL procedure successfully completed.


Function created.

No errors.
========Testing========

+-+-+-+-+-+-+-+-+-+
title_total_cost(9780201106862) should return 97.5
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


TOTAL_COST                                                                                                                                                                                                                                                                                                                                                    
----------                                                                                                                                                                                                                                                                                                                                                    
      97.5                                                                                                                                                                                                                                                                                                                                                    

+-+-+-+-+-+-+-+-+-+
title_total_cost(9780871507877) should return 1137.5
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


TOTAL_COST                                                                                                                                                                                                                                                                                                                                                    
----------                                                                                                                                                                                                                                                                                                                                                    
    1137.5                                                                                                                                                                                                                                                                                                                                                    

+-+-+-+-+-+-+-+-+-+
title_total_cost(0780471507877) should return -1
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


TOTAL_COST                                                                                                                                                                                                                                                                                                                                                    
----------                                                                                                                                                                                                                                                                                                                                                    
        -1                                                                                                                                                                                                                                                                                                                                                    


Procedure created.

No errors.
========Testing========

+-+-+-+-+-+-+-+-+-+
titles_in_range(30, 40) should output:
$31.5 - Financial Accounting: 10
$34.95 - Computers and Data Processing: 15
$35.95 - Operating Systems: A Systematic View: 5
$37.95 - An Introduction to Database Systems: 10
$37.95 - Data Base Management: 20
$37.95 - Problem Solving and Structured Programming: 12
$39.95 - The C Programming Language: 10
$40 - Software Engineering: 10
+-+-+-+-+-+-+-+-+-+
$31.5 - Financial Accounting: 10                                                                                                                                                                                                                                                                                                                              
$34.95 - Computers and Data Processing: 15                                                                                                                                                                                                                                                                                                                    
$35.95 - Operating Systems: A Systematic View: 5                                                                                                                                                                                                                                                                                                              
$37.95 - An Introduction to Database Systems: 10                                                                                                                                                                                                                                                                                                              
$37.95 - Data Base Management: 20                                                                                                                                                                                                                                                                                                                             
$37.95 - Problem Solving and Structured Programming: 12                                                                                                                                                                                                                                                                                                       
$39.95 - The C Programming Language: 10                                                                                                                                                                                                                                                                                                                       
$40 - Software Engineering: 10                                                                                                                                                                                                                                                                                                                                

PL/SQL procedure successfully completed.

+-+-+-+-+-+-+-+-+-+
titles_in_range(1, 3) should output: Nothing, no titles within this zone
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.

+-+-+-+-+-+-+-+-+-+
titles_in_range(1, 3) should output:
$28.95 - Management Information Sytems: 30
$28.95 - SPSS: 75
$29.95 - BASIC: A Structured Approach: 5
+-+-+-+-+-+-+-+-+-+
$28.95 - Management Information Sytems: 30                                                                                                                                                                                                                                                                                                                    
$28.95 - SPSS: 75                                                                                                                                                                                                                                                                                                                                             
$29.95 - BASIC: A Structured Approach: 5                                                                                                                                                                                                                                                                                                                      

PL/SQL procedure successfully completed.


Function created.

No errors.
========Testing========

+-+-+-+-+-+-+-+-+-+
get_pub('9780262534802') should return: 'The MIT Press'
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


NAME                                                                                                                                                                                                                                                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                                                                              
The MIT Press                                                                                                                                                                                                                                                                                                                                                 

========Testing========

+-+-+-+-+-+-+-+-+-+
get_pub('9780073401324') should return: 'McGraw-Hill'
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


NAME                                                                                                                                                                                                                                                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                                                                              
McGraw-Hill                                                                                                                                                                                                                                                                                                                                                   

========Testing========

+-+-+-+-+-+-+-+-+-+
get_pub('9383356033235') should return: 'ISBN not found'
+-+-+-+-+-+-+-+-+-+

PL/SQL procedure successfully completed.


NAME                                                                                                                                                                                                                                                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                                                                              
ISBN not found