Errata

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    Sep 11, 2015
Printed
Page 144
Under "Net Service Name wizard" in section headed Oracle Net Manager

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

 Anonymous    Sep 11, 2015
Printed
Page 234
Second line, last word

1027 should be 10^27

 Anonymous    Sep 11, 2015
Printed
Page 235
Last Line.

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

 Anonymous    Sep 11, 2015
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    Sep 11, 2015
Printed
Page 255
CREATE TEMPORARY TABLESPACE

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

 Anonymous    Sep 11, 2015
Printed
Page 299
BITAN function

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

 Anonymous    Sep 11, 2015
Printed
Page 300
Least

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

 Anonymous    Sep 11, 2015
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    Sep 11, 2015
Printed
Page 323
IN PRINT: "DECODE" listing, "Parameters" section, "result" explanation

"Rsult portion of..."

SHOULD BE:
"Result portion of..."

 Anonymous    Sep 11, 2015
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    Sep 11, 2015
Printed
Page 375
middle of page

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

 Anonymous    Sep 11, 2015
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    Sep 11, 2015
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    Sep 11, 2015
Printed
Page 510
DBMS_TRANSFORM

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

 Anonymous    Sep 11, 2015
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    Sep 11, 2015
Printed
Page 744
about 1/3 of the way down the page,

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

 Anonymous    Sep 11, 2015
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    Sep 11, 2015