Errata

Learning Oracle PL/SQL

Errata for Learning Oracle PL/SQL

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 28
1st paragraph

Reads:
"bounded with certain keyword (usually BEGIN and END)."
Should read:
"bounded with certain keywords (usually BEGIN and END)."

Anonymous   
Printed
Page 45
Near top of the page (after first code segment); immediately after "Where:",

"conditionn"
should be
"condition".

Anonymous   
Printed
Page 64
first code block

author VARCHR2(200)
should be:
author VARCHR2(200),

Anonymous   
Printed
Page 64
- On INSERT statement, second line should break just prior to 'Bill

Pribyl with Steven Feuerstein' (with three leading spaces on second
line) instead of in the middle of 'Steven Feuerstein'

Anonymous   
Printed
Page 64

- the book_copies creation statement currently reads:

CREATE TABLE book_copies(
barcode_id VARCHAR2(100) NOT NULL PRIMARY KEY,
isbn VARCHAR2(13) FOREIGN KEY REFERENCES books(isbn)
);

Although the text will build the table, I would like it to read
as follows int he next printing:

CREATE TABLE book_copies(
barcode_id VARCHAR2(100) NOT NULL PRIMARY KEY,
isbn VARCHAR2(13) NOT NULL,
CONSTRAINT book_copies_isbn_fk FOREIGN KEY (isbn) REFERENCES books (isbn)
);

Anonymous   
Printed
Page 74
Code Example

Book has:
'Reference for PL/SQL developers, '
should be:
'Reference for PL/SQL developers',

Anonymous   
Printed
Page 81
4th paragraph

currently reads:

Notice that book_copy_qty returns a VARCHAR2, which is a acceptable
input datatype to concatenate with text and print using PUT_LINE.

Please change that to read:

Notice that the result returned from book_copy_qty gets concatenated
with the 'Number of copies...' string as the argument to PUT_LINE.

(And, if there is space available, please add an asterisk on the word
"result" and the following footnote:
*The function returns a NUMBER, which runtime engine converts to a
string to allow the concatenation to succeed.)

Anonymous   
Printed
Page 95
- figure should have arrows to all of the smaller boxes on the

left; all six are public programs

Anonymous   
Printed
Page 100
- "add_book.sp" should be "add_book.pro"

Anonymous   
Printed
Page 101
- "reporteqnum" should be "reporteqbool"

Anonymous   
Printed
Page 109
- The section is "HTML Basics" (Chapter 4). The paragraph before

it notes "The rule says that you must close the inner element before the
outer one. Thus, the following example is logically incorrect:

<OUTER>
<INNER>
This illustrates the RIGHT way to nest elements
</INNER>
</OUTER>"

Anonymous   
Printed
Page 122
- "show_time2" show be "show_time"

Anonymous   
Printed
Page 123
Bottom of "Creating a DAD" sidebar

"Oraacle9:"
should be
"Oracle9:"

Anonymous   
Printed
Page 127
- "add_book_form1" show be "eat_add_book_form"

Anonymous   
Printed
Page 128
- "eat_add_book_form1" in text should be "eat_add_book_form"

Anonymous   
Printed
Page 152
- "??" should be 200

Anonymous   
Printed
Page 154
3rd line of short story

"shot class"
should be
"shot glass"

Anonymous   
Printed
Page 156
- "??" should be 200

Anonymous   
Printed
Page 156
- "bkcur" should be "bcur " (note space, this is for alignment)

Anonymous   
Printed
Page 160
- "??" should be 200

Anonymous   
Printed
Page 160
- "bkcur" should be "bcur"

Anonymous   
Printed
Page 163
- "bkcur" should be "bcur" (THREE OCCURRENCES)

Anonymous   
Printed
Page 165

- change "bcur%ROWCOUNT" to "brec.title"; also delete entire line that reads:

|| ') ' || brec.title

Anonymous   
Printed
Page 180
final sentence (not in code example)

Sentence starts with "Iit" where "It" was meant.

Anonymous   
Printed
Page 204
- delete entire line that says "/*file chgsince.sql*/"

Anonymous   
Printed
Page 213
- replace the missing single quote mark: "'_in" should be "'_in'"

Anonymous   
Printed
Page 255
- it would be better if the sidebar did not split up the code

Anonymous   
Printed
Page 297

{297} - replace "shortURL" with "getBytes"

Anonymous