Oracle PL/SQL Language Pocket Reference 
by Steven Feuerstein, Bill Pribyl & Chip Dawes


This page contains the changes made in the 3/01 reprint.


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


(10)  The heading of the 3rd column in the table at the center of the page 
did read:

        Oracle RDNMS Datatype

Now reads:

        Oracle RDBMS Datatype


(13)  The 2nd sentence in the 2nd paragraph did read:

        "For variable-length character sets (like JA16SJIS), the length 
        specification is in bytes; for fixed-length character sets, the it is 
        in characters."

Now reads:

        "For variable-length character sets (like JA16SJIS), the length
        specification is in bytes. For fixed-length character sets, the
        specification is in characters."


[60]  Replaced the package example with the following:

        CREATE OR REPLACE PACKAGE time_pkg IS
           FUNCTION  GetTimestamp  RETURN DATE;
           PRAGMA RESTRICT_REFERENCES (GetTimestamp, WNDS);
           PROCEDURE ResetTimestamp(inDate  DATE DEFAULT 
	      SYSDATE);
        END time_pkg;

        CREATE OR REPLACE PACKAGE BODY time_pkg IS
           StartTimeStamp   DATE := SYSDATE;
           -- StartTimeStamp is package data.
           FUNCTION GetTimestamp RETURN DATE IS
           BEGIN
              RETURN StartTimeStamp;
           END GetTimestamp;
           PROCEDURE ResetTimestamp(inDate  DATE DEFAULT 
	      SYSDATE) IS
           BEGIN
              StartTimeStamp := inDate;
           END ResetTimestamp;
        END time_pkg;