Oracle PL/SQL Programming, 2nd Edition
by Steve Feuerstein, with Bill Pribyl


The following are the changes made in the 7/00 reprint.


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


{58} The first line of the second code listing on the page did read:

        "IF to_number(the_value) > 22 AND"

Now reads:
        
        "IF TO_NUMBER(the_value) > 22 AND"


{89} The entry:

        "NATURAL
           0 through 2^31"

Now reads:

        "NATURAL
           1 through 2^31"


{137} The code line:

	"order_date >= ADD_MONTHS ... 
	'O';"

Now reads:

	"(order_date < ADD_MONTHS (SYSDATE -2) AND
 	order_status = 'O'));"


(187) The first line in the second paragraph did read: 

	"The IN and IN OUT..."

Now reads: 

	"The OUT and IN OUT..."


(311) The first line of code at top of the page did read: 

	"...name in..."

Now reads: 

	"...name_in..."


(311) The second line of code at the top of the page did read:

	"...company id..."

Now reads: 

	"...company_id..."


{425} "The NVL Function," first paragraph; in the last two lines of the code 
listing for FUNCTION NVL shown:

The third-to-last line of code did read: 

	"RETURN NUMBER"

Now reads: 

	"IN NUMBER"

The last line of code did read: 

	"RETURN BOOLEAN"

Now reads: 

	"IN BOOLEAN"


(563) The third sentence of the first full paragraph on the page did read:

	"...query at 11 a.m;..."

Now reads: 

	"...query at 10 a.m;..."


(565) The fourth line from bottom of the first code sample on the page did
read: 

	"...payment..."

Now reads: 

	"...payment_date..."


(566) The sixth line of the first code sample in section "Combining Scalar
and Aggregate Values" did read: 

	WHERE E.department_id

Now reads: 

	WHERE E1.department_id


(569) The first line of the first complete code sample did read:

	"...SELECT E.department_id..."

Now reads: 

	"...SELECT department_id..."


(817) The fifth entry in the Extension column in the table did read:

	<file>spb

Now reads: 

	<file>.spb


(908) The seventh line down in the code sample at top of page did read:

	IF debuging

Now reads: 

	IF tracing


(925) In the first line of code on the page, "=20" was removed.


(925) The fourth line of the second code sample on the page was missing ':='.

Now reads:

	pipe_status := DBMS...


(931) In the code sample at bottom of page, the word "in" has been changed 
to "IN" in both lines 4 & 6 (to match the rest of the code of the page).