Errata

Print Print Icon

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 "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



Version Location Description Submitted By 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