Errata

Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By Corrected
Printed Page 129
Problem 16-16

Change:

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

to:

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

Anonymous  Sep 2000
Printed Page 129
Part b of Problem 16-16

Change:

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

to:

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

Anonymous  Sep 2000
Printed Page 131
Part b of Problem 16-24

Change:

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

to:

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

Anonymous  Sep 2000
Printed Page 244
IN PRINT: Item 1-12

"...can have only one of three values: -1, 1, or NULL."

SHOULD BE:
"...can have only one of four values: -1, 1, 0, or NULL."

 Anonymous 
Printed Page 263
The third line of code in example 4-18

Change:

"exception unknown_sex;"

to:

"unknown_sex EXCEPTION;"


 Anonymous  Sep 2000
Printed Page 269
Solution for 4-36

it should say:

The correct answer is (c). After the first NO_DATA_FOUND is re-raised,
control is passed immediately to the outer block's exception section and then
the string displayed terminates with "No data in outer block". Following this,
PL/SQL does not return to the block to finish up by displaying "Finished test".

 Anonymous 
Printed Page 287
Part c of Solution 6-5

Change:

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

to:

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

 Anonymous  Sep 2000
Printed Page 293
Solution 6-22

Change:

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

to:

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

 Anonymous  Sep 2000
Printed Page 373
The first sentence

Change:

"The function make three inappropriate..."

to:

"The function makes three inappropriate..."

 Anonymous 
Printed Page 398
Part d of Solution 16-2

Change:

"You can create..."

to:

"Oracle8i allows you to create..."

Anonymous  Sep 2000
Printed Page 401
Part d of Solution 16-17

Change:

"...created on NESTED TABLE..."

to:

"...created on the NESTED TABLE..."

 Anonymous 
Printed Page 401
Part c of Solution 16-17

Change:

"False. Oracle8..."

to:

"True. Oracle8..."

 Anonymous  Sep 2000
Printed Page 401
Part d of Solution 16-17

Change:

"Oracle8i introduced..."

to:

"True. Oracle8i introduced..."

 Anonymous  Sep 2000
Printed Page 403
Solution 16-24

Change:

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

to:

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

 Anonymous  Sep 2000
Printed Page 545
The answer to question 29-9

Change:

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

to:

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

Anonymous  Sep 2000