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 18 2nd to last line |
"of to" |
Anonymous | ||
| Printed | Page 18 2nd to last line |
"of to" |
Anonymous | ||
| Printed | Page 23 last line |
1970-2069.The default... |
Anonymous | ||
| Printed | Page 23 last line |
1970-2069.The default... |
Anonymous | ||
| Printed | Page 27 decimal, line 3, |
bad line break |
Anonymous | ||
| Printed | Page 27 decimal, line 3, |
bad line break |
Anonymous | ||
| Printed | Page 30 line 15, |
Fix the second single quote mark. |
Anonymous | ||
| Printed | Page 30 line 15, |
Fix the second single quote mark. |
Anonymous | ||
| Printed | Page 37 REFRENCES section |
REFERENCEStable... |
Anonymous | ||
| Printed | Page 37 REFRENCES section |
REFERENCEStable... |
Anonymous | ||
| Printed | Page 41 line 6 |
resultss should be results |
Anonymous | ||
| Printed | Page 41 line 6 |
resultss should be results |
Anonymous | ||
| Printed | Page 56 line 6 |
DISTINCT | | DISTINCTROWS |
Anonymous | ||
| Printed | Page 56 line 6 |
DISTINCT | | DISTINCTROWS |
Anonymous | ||
| Printed | Page 57 "Aliases" 5th line |
are not be |
Anonymous | ||
| Printed | Page 57 "Aliases" 5th line |
are not be |
Anonymous | ||
| Printed | Page 58 "Table1, Table2, Table3, ..." line 5; |
) Only |
Anonymous | ||
| Printed | Page 58 "Table1, Table2, Table3, ..." line 5; |
) Only |
Anonymous | ||
| Printed | Page 61 line -4; |
Start with '#', not 'S' |
Anonymous | ||
| Printed | Page 61 line -4; |
Start with '#', not 'S' |
Anonymous | ||
| Printed | Page 70 AVG |
bad line break splitting "e.g." |
Anonymous | ||
| Printed | Page 70 AVG |
bad line break splitting "e.g." |
Anonymous | ||
| Printed | Page 71 STD; |
Use of '/' looks like division. Instead use ' | ' |
Anonymous | ||
| Printed | Page 71 ADDDATE |
Remove second and third commas. |
Anonymous | ||
| Printed | Page 71 STD; |
Use of '/' looks like division. Instead use ' | ' |
Anonymous | ||
| Printed | Page 71 ADDDATE |
Remove second and third commas. |
Anonymous | ||
| Printed | Page 72 BIN |
In the text, make "decimal" italic. |
Anonymous | ||
| Printed | Page 72 BIN |
In the text, make "decimal" italic. |
Anonymous | ||
| Printed | Page 74 DATE_ADD |
Remove second and third commas. |
Anonymous | ||
| Printed | Page 74 DATE_ADD |
Remove second and third commas. |
Anonymous | ||
| Printed | Page 75 DATE_SUB |
Add spaces between the words in the second parameter. |
Anonymous | ||
| Printed | Page 75 DATE_SUB |
Add spaces between the words in the second parameter. |
Anonymous | ||
| Printed | Page 83 RIGHT, |
The definition is wrong. SUBSTRING, as defined on p.85, starts counting from the left, not right. |
Anonymous | ||
| Printed | Page 83 RIGHT, |
The definition is wrong. SUBSTRING, as defined on p.85, starts counting from the left, not right. |
Anonymous | ||
| Printed | Page 84 RTRIM |
Correct the back tick to use typewriter font. |
Anonymous | ||
| Printed | Page 84 RTRIM |
Correct the back tick to use typewriter font. |
Anonymous | ||
| Printed | Page 85 SUBSTRING, |
The example for the fourth function should be with the second function. |
Anonymous | ||
| Printed | Page 85 SUBSTRING, |
The example for the fourth function should be with the second function. |
Anonymous |