Errata

Oracle SQL: the Essential Reference

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

no longer in boldface.

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