Errata for Learning Oracle PL/SQL

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

"conditionn" should be "condition".

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

- 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) );

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

left; all six are public programs

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

"Oraacle9:" should be "Oracle9:"

"shot class" should be "shot glass"

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