Errata for Oracle SQL: the Essential Reference
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 xii
The last sentence of the first full paragraph did read |
"This was the first widely circulated paper about the language that
wasProceedings of the May 1974 ACM SIGMOD Workshop on Data Description,
Access and Control to become SQL."
Now reads:
"This was the first widely circulated paper about the language that
was to become SQL."
|
Anonymous |
|
Nov 01, 2000 |
| Printed |
Page xxvi
The first two lines on the page did read |
"requirements, such as the rise of give a sense of data warehousing
and new technologies like objects, Java, and XML."
Now read:
"requirements such as data warehousing, and new technologies like
objects, Java, and XML."
|
Anonymous |
|
Jan 01, 2001 |
| Printed |
Page xxxi-xxxii
The "Comments and Questions" section has been updated. It |
now reads:
Comments and Questions
I have tested and verified the information in this book to the best of my
ability, but you may find that features have changed or that I have made
mistakes. If so, please notify me by writing to:
O'Reilly & Associates
101 Morris Street
Sebastopol, CA 95472
(800) 998-9938 (in the United States or Canada)
(707) 829-0515 (international/local)
(707) 829-0104 (fax)
There is a web site for this book, where you can find examples, errata, and
any additional information. (Previously reported errors and corrections are
available for public view there.) You can access this page at:
http://www.oreilly.com/catalog/9781565926974/
To ask technical questions or comment on the book, send email to:
bookquestions@oreilly.com
For more information about our books, conferences, software, Resource Centers,
and the O'Reilly Network, see our web site at:
http://www.oreilly.com
To contact me directly, send email to:
dkreines@usa.net
|
Anonymous |
|
Jan 01, 2001 |
| Printed |
Page xiii
In the third line |
"DDL is comprised of the verbs SELECT, INSERT, UPDATE..."
Has been changed to:
"DML is comprised of the verbs SELECT, INSERT, UPDATE..."
|
Anonymous |
|
Sep 01, 2001 |
| Printed |
Page 9-10
The date referenced in the code samples at the bottom of page 9 and |
the top of page 10 did not match that mentioned in the text in the last
paragraph on page 9 and the first paragraph on page 10. Therefore:
"07-Jul-76"
Has been changed to:
"04-Jul-76"
|
Anonymous |
|
Sep 01, 2001 |
| Printed |
Page 85
The 2nd-4th lines in the syntax for CREATE/ALTER/DROP TABLE did read |
(column datatype [DEFAULT expression] [Column_Contraint]
[,column datatype [DEFAULT expression] [Column_Contraint]]...)
[Table_Contraint_Clause]
Now read:
(column datatype [DEFAULT expression] [Column_Constraint]
[,column datatype [DEFAULT expression] [Column_Constraint]...]
[Table_Constraint_Clause])
|
Anonymous |
|
Jan 01, 2001 |
| Printed |
Page 91
First example |
There is too much space before NUMBER(2) NOT NULL. This line should line up
with VARCHAR2 below. Also, third line VARCHAR should be VARCHAR2.
|
Anonymous |
|
Sep 01, 2001 |
| Printed |
Page 92
The ALTER TABLESPACE syntax |
ALTER TABLESPACE tablespace_name
...
...
[RENAME 'filename1` TO 'filename2']
Has been changed to:
ALTER TABLESPACE tablespace_name
...
...
[RENAME DATAFILE 'filename1' TO 'filename2']
|
Anonymous |
|
Sep 01, 2001 |
| Printed |
Page 166
Example for LPAD function |
"X YYX LEFTLEFTRIGHT"
Has been changed to:
"X YYX LEFTLEFRIGHT"
|
Anonymous |
|
Sep 01, 2001 |
| Printed |
Page 170
In the first RTRIM example, the 2 at the beginning of the 2nd line is |
|
Anonymous |
|
Sep 01, 2001 |
| Printed |
Page 370
The third line in the left column did read |
"returning current, 181"
Now reads:
"returning current, 180"
|
Anonymous |
|
Jan 01, 2001 |
|
| |
