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 xv
Preface |
The following information was added to the preface:
"How to Contact Us
We have tested and verified the information in this book to
the best of our ability, but you may find that features have
changed (or even that we have made mistakes!). Please let us
know about any errors you find, as well as your suggestions
for future editions, by writing to:
O'Reilly & Associates, Inc.
101 Morris Street
Sebastopol, CA 95472
1-800-998-9938 (in the U.S. or Canada)
1-707-829-0515 (international/local)
1-707-829-0104 (FAX)
You can also send us messages electronically. To be put on the
mailing list or request a catalog, send email to:
info@oreilly.com
To ask technical questions or comment on the book, send email
to:
bookquestions@oreilly.com
We have a web site for the book, where we'll list examples,
errata, and any plans for future editions. You can access this
page at:
http://www.oreilly.com/catalog/9781565926752/
For more information about this book and others, see the O'Reilly
web site:
http://www.oreilly.com"
|
Anonymous |
|
Jan 01, 2000 |
Printed |
Page 37
Last sentence |
Change:
"...privileges and roles..."
to:
"...directly-granted privileges..."
|
Anonymous |
|
Jan 01, 2000 |
Printed |
Page 39
second bulleted item |
The second bulleted item was, unfortunately, completely wrong.
It now reads:
"The invoker rights model checks the directly-granted
privileges assigned to the invoker at the time of program
execution to resolve any external references to database
objects (but not PL/SQL program units). Even with invoker
rights, however, roles are ignored."
|
Anonymous |
|
Jan 01, 2000 |
Printed |
Page 101
The results are as follows... |
Replace the text after the paragraph beginning "The results are as follows..." with the following text:
Single row fetch 10000 Elapsed: .37 seconds.
BULK COLLECT 10000 Elapsed: .05 seconds.
Single row fetch 100000 Elapsed: 4.1 seconds.
BULK COLLECT 100000 Elapsed: .64 seconds.
Single row fetch 200000 Elapsed: 9.82 seconds.
BULK COLLECT 200000 Elapsed: 1.27 seconds.
Single row fetch 1000000 Elapsed: 46.8 seconds.
BULK COLLECT 1000000 Elapsed: 8.99 seconds.
Again, we see significant improvements in performance. Notice, however,
that the elapsed time difference between row-by-row fetches and BULK
COLLECT diminishes as the number of rows processed grows. This
undoubtedly has to do with the overhead of caching large volumes of
data before passing them back to the calling program.
|
Anonymous |
|
|
Printed |
Page 226
bulleted list at the top of the page |
The following item has been added to the bulleted list at the top of the page:
"* The trim_char may consist of only a single character."
Also, all references to "trim_chars" in the section "The TRIM Funtion" on
pages 225-226 have been changed to "trim_char."
|
Anonymous |
|
Oct 01, 2000 |
Printed |
Page 226
code sample |
The code sample on this page did read:
*****************
DECLARE
mystr VARCHAR2(10);
yourstr VARCHAR2(10) := 'Toronto';
BEGIN
DBMS_OUTPUT.PUT_LINE (
TRIM (LEADING 'x' FROM 'xyzabc'));
DBMS_OUTPUT.PUT_LINE (
TRIM (TRAILING 'cb' FROM 'xyzabc'));
DBMS_OUTPUT.PUT_LINE (
TRIM (BOTH 'x1' FROM '1x1yzabc111x'));
DBMS_OUTPUT.PUT_LINE (
TRIM ('x1' FROM '1x1yzabc111x'));
DBMS_OUTPUT.PUT_LINE (
TRIM (mystr FROM yourstr));
END;
/
*****************
Now reads:
*****************
DECLARE
mystr VARCHAR2(10);
yourstr VARCHAR2(10) := 'Toronto';
BEGIN
DBMS_OUTPUT.PUT_LINE (
TRIM (LEADING 'x' FROM 'xyzabc'));
DBMS_OUTPUT.PUT_LINE (
TRIM (TRAILING 'c' FROM 'xyzabcccc'));
DBMS_OUTPUT.PUT_LINE (
TRIM (BOTH 'x' FROM 'x1yzabc111x'));
DBMS_OUTPUT.PUT_LINE (
NVL (TRIM (mystr FROM yourstr), 'NULL'));
END;
/
*****************
|
Anonymous |
|
Oct 01, 2000 |