Oracle in a Nutshell
by David C. Kreines, Rick Greenwald

This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated February 01, 2006.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:


(xvi)  4th;
link http://www.oreilly.com/catalog/oraclenut
is no longer valid.
Link is now http://www.oreilly.com/catalog/9780596003364


(144)  Under "Net Service Name wizard" in section headed Oracle Net Manager;
"TNSNAME.ORA file" should be "TNSNAMES.ORA file"


(234)  Second line, last word;
1027 should be 10^27


(235)  Last Line.;
CREATE SPFILE[='pfile_name'] FROM PFILE [='spfile_name']
should read ...
CREATE SPFILE[='spfile_name'] FROM PFILE [='pfile_name']


(253)  CREATE/ALTER/DROP TABLESPACE;
It is missing the optional parm BLOCKSIZE.
This line should be included under "[ONLINE | OFFLINE]"
 [BLOCKSIZE integer [K]]


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


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


(300)  Least;
Last line of the description of least: 
"...the greatest value" 
should read 
"...the least value"


[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.)


(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.


(323) IN PRINT: "DECODE" listing, "Parameters" section, "result" explanation;
"Rsult portion of..."

SHOULD BE:
"Result portion of..."


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


(375) middle of page;
"Oracle PL/SQL Programming, 3ed Edition"
should be
"Oracle PL/SQL Programming, 3rd Edition."


[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.


[502]  First entry;
The procedure DBMS_STATS.GATHER_DATABASE_STATS does not take an intitial argument for
'ownname'. The first parameter is 'estimate_percent'.


{510} DBMS_TRANSFORM
All three procedures are given as CREATE_TRANSFORMATION.
They should be
CREATE_TRANSFORMATION, MODIFY_TRANSFORMATION and DROP_TRANSFORMATION


(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.


(744) about 1/3 of the way down the page,
"STARUP MOUNT;" 
should be 
"STARTUP MOUNT;"



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