Errata for Oracle PL/SQL Best Practices
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 "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 xv
URL after fourth paragraph |
NOW READS:
http://www.quest-pipelines.com/pipelines/dba/PLVision/plvision.htm
|
Anonymous |
|
Nov 01, 2004 |
| Printed |
Page 18
Bad URL |
http://www.oreilly.com/oracle/oraclep2/
NOW READS:
http://www.oreilly.com/catalog/oraclep2/
|
Anonymous |
|
Nov 01, 2003 |
| Printed |
Page 42
Second code example |
As a much better approach it is written:
DECLARE
my_birthdate DATE :=
TO_DATE ('09-SEP-58', 'DD-MON-RR');
Still this code is relying on the external setting of NLS_DATE_LANGUAGE.
The code should thus be:
DECLARE
my_birthdate DATE :=
TO_DATE ('09-SEP-58', 'DD-MON-RR', 'NLS_DATE_LANGUAGE=''AMERICAN''')
|
Anonymous |
|
|
| Printed |
Page 72
5th line from the bottom of the page |
LOOP
IF list_in...
NOW READS:
LOOP
EXIT WHEN indx IS NULL;
IF list_in...
|
Anonymous |
|
Nov 01, 2003 |
| Printed |
Page 99
The paragraph beginning |
'Application improvement is likely to improve......'
NOW READS:
'Application performance is likely to improve......'
|
Anonymous |
|
May 01, 2006 |