Errata

"In 1991, Oracle Corporation released Version 6.0 ..."

NOW READS:
"In 1988, Oracle Corporation released Version 6.0 ..."

SQL SET AUTOMCOMMIT OFF

NOW READS:
SQL SET AUTOCOMMIT OFF

FROM occupancy WHERE occupied_dt = TRUNC (SYSDATE;)

NOW READS:
FROM occupancy WHERE occupied_dt = TRUNC (SYSDATE);

the same error was repeated in the middle of the same page and is likewise CORRECTED.

DBMS_OUTPUT.PUTLINE --(occurs twice without underscore)

NOW READS:
DBMS_OUTPUT.PUT_LINE

l_stevenCONSTANT person :=

NOW READS:
l_steven CONSTANT person :=

"...CONCAT(CONCAT('abc','def'),'efg')

NOW READS:
"...CONCAT(CONCAT('abc','def'),'ghi')

"...the word "ijzen" (Dutch for "iron")..."

NOW READS:
"...the word "ijzer" (Dutch for "iron")..."

CREATE TABLE good_for

NOW READS:
CREATE TABLE shelf_life

SYEAR, YEAR SYear,

NOW READS:
SYEAR, YEAR, SYear,

The fourth element in the record structure is actually --

total_sales company_sales_cur.total_sales%TYPE := 0,

but there was a mino typo and it reads --

total_sales company-sales.total_sales%TYPE := 0,

INDEX BY VARCHAR2(size_limit)

SHOULD BE:

INDEX BY PLS_INTEGER
INDEX BY NATURAL
INDEX BY POSITIVE
INDEX BY VARCHAR2(size_limit)
INDEX BY table.column%TYPE
INDEX BY package.variable%TYPE
INDEX BY subtype

where the datatype of any anchored type or subtype resolves to VARCHAR2.

capitalization is not the normal standard on this page
e.g. "into", "varchar2", "column_value", "cast"

WHERE falls_name='Tannery Falls';

NOW READS:
WHERE falls_name='Dryer Hose';

PRAGMA
AUTONOMOUS_TRANSACTION

should be:

PRAGMA
AUTONOMOUS_TRANSACTION;

"BEGIN
OPEN sess; FETCH sess INTO rec; CLOSE sess;"

These two lines of code HAVE BEEN DELETED.

page 491,
SQL%FOUND (in code and text)

NOW READS:
SQL%ROWCOUNT

l_foundsome BOOLEAN;

NOW READS:
l_numfound PLS_INTEGER;

l_foundsome := SQL%FOUND

NOW READS:
l_numfound := SQL%ROWCOUNT

page 503
IN PRINT:
bard_rec bard_cur%ROWTYPE

NOW READS:
bard_rec bookinfo_pkg.bard_cur%ROWTYPE

page 504,
CLOSE bcur;

NOW READS:
CLOSE bard_cur;

RESTRICT_REFEFRENCES

NOW READS:
RESTRICT_REFERENCES

...functions defined in built-packages...

NOW READS:
...functions defined in built-in packages...

"INTEAD OF..."
should be:
"INSTEAD OF..."

FUNCTION DBMS_REUSABLE.<Name>
and
PROCEDURE DBMS_REUSABLE.<Name>

NOW READ:
FUNCTION DBMS_RESUMABLE.<Name>
and
PROCEDURE DBMS_RESUMABLE.<Name>

INVALID_STATE

NOW READS:
INVALID_TRIGGER

Writing the code for an application is just one step toward putting that
production into application and then maintaining the code base.

NOW READS:
Writing the code for an application is just one step toward putting that
application into production and then maintaining the code base.

...relies not so much "depends-on" information as it does on "referenced-by"
information.

NOW READS:
...relies not so much on "depends-on" information as it does on "referenced-by"
information.

prv_book_cur_status := book_main.book_cur%FOUND;

NOW READS:
prv_book_cur_status := book_maint.book_cur%FOUND;