Oracle in a Nutshell

Errata for Oracle in a Nutshell

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 xvi
4th

link http://www.oreilly.com/catalog/oraclenut is no longer valid. Link is now http://www.oreilly.com/catalog/9780596003364

Anonymous   
Printed
Page 144
Under "Net Service Name wizard" in section headed Oracle Net Manager

"TNSNAME.ORA file" should be "TNSNAMES.ORA file"

Anonymous   
Printed
Page 234
Second line, last word

1027 should be 10^27

Anonymous   
Printed
Page 235
Last Line.

CREATE SPFILE[='pfile_name'] FROM PFILE [='spfile_name'] should read ... CREATE SPFILE[='spfile_name'] FROM PFILE [='pfile_name']

Anonymous   
Printed
Page 253
CREATE/ALTER/DROP TABLESPACE

It is missing the optional parm BLOCKSIZE. This line should be included under "[ONLINE | OFFLINE]" [BLOCKSIZE integer [K]]

Anonymous   
Printed
Page 255
CREATE TEMPORARY TABLESPACE

The syntax is missing the tablespace name. It should read: CREATE TEMPORARY TABLESPACE <tablespace_name> ...

Anonymous   
Printed
Page 299
BITAN function

BITAN BITAN (n,m) should read: BITAND BITAND (n,m)

Anonymous   
Printed
Page 300
Least

Last line of the description of least: "...the greatest value" should read "...the least value"

Anonymous   
Printed
Page 304
2nd item - LTRIM

The second param should be a "set" not a "string". (we should note that it will remove any and all characters in 'set' on the leftmost of the target until it reaches a character not in 'set', at which point it stops removing characters and returns what remains.)

Anonymous   
Printed
Page 306
SUBSTR description

please add this note to the description: The offset parameter for the SUBSTR function is 1-based, meaning the first position is referred to as 1, the second as 2, and so on.

Anonymous   
Printed
Page 323
IN PRINT: "DECODE" listing, "Parameters" section, "result" explanation

"Rsult portion of..." SHOULD BE: "Result portion of..."

Anonymous   
Printed
Page 325
NVL2 function

"Returns either expr2 or expr3. If expr1 is NULL, the function returns expr2; otherwise, it returns expr3." Should be: "Returns either expr2 or expr3. If expr1 is NULL, the function returns expr3; otherwise, it returns expr2."

Anonymous   
Printed
Page 375
middle of page

"Oracle PL/SQL Programming, 3ed Edition" should be "Oracle PL/SQL Programming, 3rd Edition."

Anonymous   
Printed
Page 434
DBMS_OBFUSCATION_TOOLKIT

The last of the call syntaxes shows a second copy of the DESDECRYPT syntax over a description of DES3DECRYPT. The last procedure in this package should be called - PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3DECRYPT. It should have a fourth parameter, the which parameter in the previous call. And the word 'which' in both descriptions should be in italics.

Anonymous   
Printed
Page 502
First entry

The procedure DBMS_STATS.GATHER_DATABASE_STATS does not take an intitial argument for 'ownname'. The first parameter is 'estimate_percent'.

Anonymous   
Printed
Page 510
DBMS_TRANSFORM

All three procedures are given as CREATE_TRANSFORMATION. They should be CREATE_TRANSFORMATION, MODIFY_TRANSFORMATION and DROP_TRANSFORMATION

Anonymous   
Printed
Page 678
at the bottom of the page in the section, "Formatting Dates."

The references to "Table B-1" and "Appendix B" should point to "Table D-1 and Appendix D" instead.

Anonymous   
Printed
Page 744
about 1/3 of the way down the page,

"STARUP MOUNT;" should be "STARTUP MOUNT;"

Anonymous   
Printed
Page 808
ONLINE: 4th paragraph

The PDF sample chapter under the heading Histograms, contains an sentence fragment (incomplete paragraph??). It simply states, "Histograms were", ending without a period, and proceeds on to the next heading. SHOULD BE: "Histograms were introduced with Oracle8i."

Anonymous