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 18
2nd to last line |
"of to"
should be:
"of 0 to"
|
Anonymous |
|
|
| Printed |
Page 18
2nd to last line |
"of to"
should be:
"of 0 to"
|
Anonymous |
|
|
| Printed |
Page 23
last line |
1970-2069.The default...
should be:
1970-2069. The default...
|
Anonymous |
|
|
| Printed |
Page 23
last line |
1970-2069.The default...
should be:
1970-2069. The default...
|
Anonymous |
|
|
| Printed |
Page 27
decimal, line 3, |
|
Anonymous |
|
|
| Printed |
Page 27
decimal, line 3, |
|
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...
should be:
REFERENCES table...
|
Anonymous |
|
|
| Printed |
Page 37
REFRENCES section |
REFERENCEStable...
should be:
REFERENCES table...
|
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
should be:
DISTINCT | DISTINCTROWS
|
Anonymous |
|
|
| Printed |
Page 56
line 6 |
DISTINCT | | DISTINCTROWS
should be:
DISTINCT | DISTINCTROWS
|
Anonymous |
|
|
| Printed |
Page 57
"Aliases" 5th line |
are not be
should be:
have not been
|
Anonymous |
|
|
| Printed |
Page 57
"Aliases" 5th line |
are not be
should be:
have not been
|
Anonymous |
|
|
| Printed |
Page 58
"Table1, Table2, Table3, ..." line 5; |
) Only
should be:
). Only
|
Anonymous |
|
|
| Printed |
Page 58
"Table1, Table2, Table3, ..." line 5; |
) Only
should be:
). Only
|
Anonymous |
|
|
| Printed |
Page 61
line -4; |
|
Anonymous |
|
|
| Printed |
Page 61
line -4; |
|
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 |
|
|
