Errata
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.
Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted By | Date submitted | Date corrected |
---|---|---|---|---|---|
Printed | Page 4 Last paragraph; |
"In 1991, Oracle Corporation released Version 6.0 ..." |
Anonymous | Oct 01, 2003 | |
Printed | Page 15 IN PRINT: first line of the first example |
CREATE TYPE empnos_list_t IS VARRARY(100) OF NUMBER; |
Anonymous | Feb 01, 2003 | |
Printed | Page 15 both examples |
CREATE OR REPLACE del_emps |
Anonymous | Feb 01, 2003 | |
Printed | Page 15 IN PRINT: del_emps procedure |
FORALL listnum IN list_in.FIRST .. list_in.LAST |
Anonymous | Feb 01, 2003 | |
Printed | Page 17 Oracle 9i New Features, Record-based DML, concerning INSERT a row-level struture. |
INSERT INTO books VALUES (book_in); |
Anonymous | Sep 01, 2004 | |
Printed | Page 40 IN PRINT: Half way down |
SQL SET AUTOMCOMMIT OFF |
Anonymous | Feb 01, 2003 | |
Printed | Page 74 Last line above footnote |
"SQL> SELECT * FROM V$RESERVED_WORD;" |
Anonymous | Feb 01, 2003 | |
Printed | Page 109 IN PRINT: 5th row from the bottom |
Rows 4 and 5 from the bottom: |
Anonymous | Feb 01, 2003 | |
Printed | Page 109 Section titled 'The simple loop' |
The second sentence reads: "Notice the IF statement used to guard against executing |
Anonymous | ||
Printed | Page 119 line 4 |
FROM occupancy WHERE occupied_dt = TRUNC (SYSDATE;) |
Anonymous | Sep 01, 2004 | |
Printed | Page 143 Bottom of code |
DBMS_OUTPUT.PUTLINE --(occurs twice without underscore) |
Anonymous | Oct 01, 2003 | |
Printed | Page 161 Last declaration in the sample code section |
l_stevenCONSTANT person := |
Anonymous | Oct 01, 2003 | |
Printed | Page 199 IN PRINT: 2nd last para in CONCAT |
"...CONCAT(CONCAT('abc','def'),'efg') |
Anonymous | Feb 01, 2003 | |
Printed | Page 221 Halfway down the page, first bulleted example |
The result of the first example was incorrectly listed without the trailing period. |
Anonymous | Oct 01, 2003 | |
Printed | Page 224 IN PRINT: 1st paragraph |
"...the word "ijzen" (Dutch for "iron")..." |
Anonymous | Feb 01, 2003 | |
Printed | Page 264 IN PRINT: Bottom - expiration_date function |
CREATE TABLE good_for |
Anonymous | Feb 01, 2003 | |
Printed | Page 268 second to last line; missing a comma. |
SYEAR, YEAR SYear, |
Anonymous | Oct 01, 2003 | |
Printed | Page 280 IN PRINT: 4th paragraph |
"With RR you can enter dates from the 21st century before the year 2000, |
Anonymous | Feb 01, 2003 | |
Printed | Page 307 IN PRINT: Last paragraph, last three lines below table 10-6 |
"The following example illustrates the difference between CURRENT_TIMESTAMP, which |
Anonymous | Oct 01, 2003 | |
Printed | Page 328 Code in the second bulletted list |
The fourth element in the record structure is actually -- |
Anonymous | ||
Printed | Page 342 IN PRINT: 2nd line from the top |
INDEX BY VARCHAR2(size_limit) |
Anonymous | ||
Printed | Page 357 5th line |
"...i is greater then COUNT..." |
Anonymous | ||
Printed | Page 376 1st paragraph (example) |
Under line 19 in the code sample, the folliwng line WAS ADDED: |
Anonymous | Sep 01, 2004 | |
Printed | Page 390 1st paragraph |
capitalization is not the normal standard on this page |
Anonymous | ||
Printed | Page 407 In the code listing at the very top of page 407 |
WHERE falls_name='Tannery Falls'; |
Anonymous | Oct 01, 2003 | |
Printed | Page 464 figure 13-4 |
PRAGMA |
Anonymous | ||
Printed | Page 469 Last Line |
DECLARE |
Anonymous | Feb 01, 2003 | |
Printed | Page 472 IN PRINT: code example, last three lines |
"BEGIN |
Anonymous | Oct 01, 2003 | |
Printed | Page 472 IN PRINT: first bulleted item on list, HAS BEEN DELETED. |
Anonymous | Sep 01, 2004 | ||
Printed | Page 493 IN PRINT: jealousy_level package |
Line 25... |
Anonymous | Feb 01, 2003 | |
Printed | Page 599 IN PRINT: Example at top of page |
"PROCEDURE value_ok (number_in IN NUMBER) RETURN BOOLEAN" |
Anonymous | Feb 01, 2003 | |
Printed | Page 605 "Requirements for calling functions", 4th bullet point |
RESTRICT_REFEFRENCES |
Anonymous | Oct 01, 2003 | |
Printed | Page 659 Last item in first bulleted list |
...functions defined in built-packages... |
Anonymous | Oct 01, 2003 | |
Printed | Page 693 6th line of code from the bottom |
"INTEAD OF..." |
Anonymous | ||
Printed | Page 698 top, code sample |
In this INSTEAD OF DELETE trigger, the reference to |
Anonymous | ||
Printed | Page 704 IN PRINT: Bottom |
FUNCTION DBMS_REUSABLE.<Name> |
Anonymous | Oct 01, 2003 | |
Printed | Page 709 IN PRINT: Last line |
INVALID_STATE |
Anonymous | Feb 01, 2003 | |
Printed | Page 710 First sentence of the chapter! |
Writing the code for an application is just one step toward putting that |
Anonymous | Oct 01, 2003 | |
Printed | Page 767 Last paragraph |
...relies not so much "depends-on" information as it does on "referenced-by" |
Anonymous | Oct 01, 2003 | |
Printed | Page 799 In the body of the next_book_rec function |
prv_book_cur_status := book_main.book_cur%FOUND; |
Anonymous | Oct 01, 2003 | |
Printed | Page 806 Code sample at bottom, third line of code |
AUTHID CURRENT_USER IS |
Anonymous | Oct 01, 2003 | |
Printed | Page 852 example for creating catalog_history |
On page 852,the CREATE TABLE code at the top of the page HAS BEEN REVISED to read as follows: |
Anonymous | Oct 01, 2003 |