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 xvii |
Anonymous | Oct 01, 1999 | ||
Printed | Page xviii |
Anonymous | Oct 01, 1999 | ||
Printed | Page xxii |
Anonymous | Oct 01, 1999 | ||
Printed | Page Part VII, 771 |
Anonymous | Oct 01, 1999 | ||
Printed | Page xviii-xxii The following text was added to the preface |
"We have tested and verified the information in this book |
Anonymous | Feb 01, 2000 | |
Printed | Page 24 |
last bullet now reads: |
Anonymous | Aug 01, 1997 | |
Printed | Page 154 |
The text in the second example used to read: |
Anonymous | Feb 01, 2000 | |
Printed | Page 170 line 5: changed |
BY DECODE(:BLK.SEQN_FLD 'E', emp_no, 'D', dept_no); |
Anonymous | May 01, 1998 | |
Printed | Page 174 code 1, line 1: changed "dpt_no" to "dept_no" |
Anonymous | Dec 01, 1997 | ||
Printed | Page 180 "Note" changed: both "WHEN"s changed to "WHERE" |
Anonymous | Dec 01, 1997 | ||
Printed | Page 183 |
code 2, line 4 now reads: |
Anonymous | Dec 01, 1997 | |
Printed | Page 186 line 7: changed WHERE EMp_NO > 0 to WHERE emp_no > 0 |
Anonymous | May 01, 1998 | ||
Printed | Page 193 bottom of the example: changed |
sum_sick_leave(E.emp_no) sick_days, |
Anonymous | May 01, 1998 | |
Printed | Page 194 # inl_outj.sql script: removed the third AND |
Anonymous | May 01, 1998 | ||
Printed | Page 203 example script, line 2: changed |
sql> SELECT sql_text, executions, |
Anonymous | May 01, 1998 | |
Printed | Page 211 2nd code block, after 4th line, add |
sal_val >= 8001 Then |
Anonymous | Dec 01, 1998 | |
Printed | Page 370 line -8, third list item: changed LOG_ENTRY_PREBUILD_THRESHOLD |
to _LOG_ENTRY_PREBUILD_THRESHOLD |
Anonymous | May 01, 1998 | |
Printed | Page 427 |
Anonymous | Oct 01, 1999 | ||
Printed | Page 430 9th line |
The FROM statement of objstor.sql used to read: |
Anonymous | Jun 01, 2001 | |
Printed | Page 451 Bottom of the page |
A comma has been added to the end of the seventh line of code: |
Anonymous | Jun 01, 2001 | |
Printed | Page 458 |
The bulleted item at the top of the page used to read: |
Anonymous | Jun 01, 2001 | |
Printed | Page 466 |
Bottom of the page used to read: |
Anonymous | Jun 01, 2001 | |
Printed | Page 469 Bottom of the page |
There is now a join required in both SQL statements. They now read as follows: |
Anonymous | Jun 01, 2001 | |
Printed | Page 471 line -8, changed DB_BUFFER_BLOCKS to DB_BLOCK_BUFFERS |
Anonymous | May 01, 1998 | ||
Printed | Page 472 |
In the code example, it used to read: |
Anonymous | Jun 01, 2001 | |
Printed | Page 475 Tenth line from the top |
The line "AND username is not null" has been added. |
Anonymous | Jun 01, 2001 | |
Printed | Page 475 Ninth line from the bottom |
The line "AND se.username is not null" has been added. |
Anonymous | Jun 01, 2001 | |
Printed | Page 476 In the first full code |
The line, "and ob_typ = 2", has been removed. |
Anonymous | Jun 01, 2001 | |
Printed | Page 476 In the second full code, the last line has been removed and the second |
to last line has been changed. |
Anonymous | Jun 01, 2001 | |
Printed | Page 513 Middle of the page |
"No responses" |
Anonymous | Jun 01, 2001 | |
Printed | Page 513 Middle of the page |
The quotation marks have been changed in the line: |
Anonymous | Jun 01, 2001 | |
Printed | Page 514 |
Top of the page used to read: |
Anonymous | Jun 01, 2001 | |
Printed | Page 514 Top of the page |
The quotation marks have been changed in the line: |
Anonymous | Jun 01, 2001 | |
Printed | Page 515 In # locksql.sql |
In line 1, "sid" has been changed to "ses.sid" |
Anonymous | Jun 01, 2001 | |
Printed | Page 516 |
The eleventh line form the top used to read: |
Anonymous | Jun 01, 2001 | |
Printed | Page 518 Top of page |
All the references to V$SQLAREA have been changed to V$SQLTEXT. |
Anonymous | Jun 01, 2001 | |
Printed | Page 518 Top of page |
A Order by line has been added to the bottom of the script: |
Anonymous | Jun 01, 2001 | |
Printed | Page 588 in the next-to-last line of para. 1, changed "megabytes" to |
"gigabytes" |
Anonymous | Dec 01, 1997 | |
Printed | Page 588 replaced the exp_lrge.sql script. For the new script, return to |
the book's web page and click on the "Book Examples via ftp" link. |
Anonymous | May 01, 1998 | |
Printed | Page 653 line 4: "99" changed to "1" |
Anonymous | Aug 01, 1997 | ||
Printed | Page 923 |
Any references that may have been missed, and still refer to the disk, |
Anonymous | Oct 01, 1999 | |
Printed | Page 942 The following text was removed from the Colophon |
"Whenever possible, our books use RepKover, a durable and |
Anonymous | Feb 01, 2000 | |
Printed | Page 942 Colophon, para. -2: added the following sentences |
"Whenever possible, our books use RepKover, a durable and flexible |
Anonymous | Aug 01, 1997 |