Oracle PL/SQL Developer's Workbook
by Steven Feuerstein with Andrew Odewahn


Following are the changes made in the 9/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


(129)  Part a of Problem 16-16 did read:

	"...database schema if she has..." 

Now reads:

	"...database schema if the user has..." 


(129)  Part b of Problem 16-16 did read:

	"...if she has the CREATE..." 

Now reads:

	"...if the user has the CREATE..." 


(131)  Part b of Problem 16-24 did read:

	"...granted directly from the user..." 

Now reads:

	"...granted directly to the user..." 


[263]  The third line of code in example 4-18 did read: 

        "exception unknown_sex;"

Now reads: 

        "unknown_sex EXCEPTION;"
      
       
(287)  Part c of Solution 6-5 did read: 

        "c. True. Index-by tables cannot be saved in the database..."

Now reads:

        "c. False. Index-by tables cannot be saved in the database..."


[293]  Solution 6-22 did read:

        the_table (NVL (the_table.FIRST, 0) + 1) := 2067;

Now reads:

        the_table (NVL (the_table.LAST, 0) + 1):= 2067;


(398)  Part d of Solution 16-2 did read:

	"You can create..." 

Now reads:

	"Oracle8i allows you to create..." 


(401)  Part c of Solution 16-17 did read:

	"False. Oracle8..." 

Now reads:

	"True. Oracle8..."


(401)  Part d of Solution 16-17 did read:

	"Oracle8i introduced..." 

Now reads:

	"True. Oracle8i introduced..."


(403)  Solution 16-24 did read:

	"...granted directly by the owner..." 

Now reads:

	"...granted directly to the trigger owner..."


[545]  The answer to question 29-9 did read: 

        "(e). You can use the DBMS_SESSION package to keep..."

Now reads:  

        "(d). You can use the DBMS_SHARED_POOL package (using the KEEP 
        procedure) to keep..."