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 "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page 129
Problem 16-16 |
Change:
"...database schema if she has..."
to:
"...database schema if the user has..."
|
Anonymous |
|
Sep 01, 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 01, 2000 |
| Printed |
Page 131
Part b of Problem 16-24 |
Change:
"...granted directly from the user..."
to:
"...granted directly to the user..."
|
Anonymous |
|
Sep 01, 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 01, 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 01, 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 01, 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 01, 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 01, 2000 |
| Printed |
Page 401
Part d of Solution 16-17 |
Change:
"Oracle8i introduced..."
to:
"True. Oracle8i introduced..."
|
Anonymous |
|
Sep 01, 2000 |
| Printed |
Page 403
Solution 16-24 |
Change:
"...granted directly by the owner..."
to:
"...granted directly to the trigger owner..."
|
Anonymous |
|
Sep 01, 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 01, 2000 |
