SQL and Relational Theory

Errata for SQL and Relational Theory

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 120
3rd bullet item

Delete this bullet item

C.J. Date
C.J. Date
O'Reilly Author 
Feb 08, 2013 
PDF
Page 132
2nd paragraph (SQL text)

I think the second instance of "FROM S )" should read "FROM P )".

paul c  Jan 23, 2013 
Printed
Page 163
Para. beginning "That said", line 2

The smart quotes following the symbols "<" and ">" should be closing quotes, not opening ones

C.J. Date
C.J. Date
O'Reilly Author 
Feb 08, 2013 
Printed
Page 206
1st bullet item

In the sentence beginning "For one thing", replace "For one thing" by "To be specific". Delete the sentence beginning "For another" (including the immediately following SQL expression).

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 209
SQL code lines

In the code lines beginning ON DELETE nls and ON INSERT nls, replace LS by NLS.

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 318
Para. beginning "We see", line 3

Replace "relvar S" by "relvar SC"

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 319
First code line

Replace "S" by "SC".

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 319
Code block at foot of page

In lines 1, 4, and 7, replace "S" by "SC"

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 320
Code block

In lines 2 and 8, replace "S.*" by "*". In line 16, replace "S.SNO" by "SNO". In lines 3, 9, and 17, replace "FROM S" by "FROM SC".

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 415
Annotation to reference [33]

In line 2, replace "features (see" by "features--see"

C.J. Date
C.J. Date
O'Reilly Author 
Feb 22, 2012 
Printed
Page 432
index entry for FORALL

in subentry "not in SQL", add page number 241

C.J. Date
C.J. Date
O'Reilly Author 
Feb 08, 2013