Oracle PL/SQL Programming
by Steve Feuerstein, with Bill Pribyl


Following are the changes made in the 3/00 reprint:



{109} In the last section of code, the third line did read:

        "the first parameter is date."

It now reads:

        "the second parameter is date."



(127) At the bottom of the page, in the very last line it did read:
        
        "Use a rectype prefix..." 

but the example shows rectype being used as a suffix. 

Now reads: 

	"Use a rectype suffix..."


{217} In the "Terminating a simple loop" section, the first example of code
did read:

        EXIT:
        EXIT WHEN condition; 

It now reads:

        EXIT;
        EXIT WHEN condition; 



{238} The second line of the second to last paragraph now reads;

	"...not the employee_id)"

It now reads:

	"...not the pet_id)"


(279) The first sentence in the first full paragraph did read:

        "The record or tuple structure..."

Now reads:

        "The table.column structure..."

The fourth line in this paragraph did read:

        "The rest of this chapter show..."

Now reads: 

        "The rest of this chapter shows..."



{291} The last line of the code in the middle of the page did read:

        WHERE sold_on BETWEEN < ADD_MONTHS (SYSDATE, -3)

It now reads:

        WHERE sold_on < ADD_MONTHS (SYSDATE, -3)

ie, BETWEEN has been removed.



(302) The last line did read:

        "5            TABLE OF VARCHAR2(30) INDEXED BY BINARY_INTEGER;"


It now reads:

        "5            TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;"




(303) The first paragraph, second sentence did read:

        "The INDEXED BY BINARY_INTEGER clause"

It now reads:

        "The INDEX BY BINARY_INTEGER clause"



{323} The 7th line of code from the bottom did read:

        primary_keys_tabtype

It now reads:

        company_keys_tabtype



{378} The two lines of code before the last paragraph did read:

        last_space_loc := INSTR (fullname_int, ' ', -1, 1);
        lname_out   := SUBSTR (fullname_int, delim_space+1);

Now read:

        last_space_loc := INSTR (fullname_int, ' ', -1, 1);
        lname_out   := SUBSTR (fullname_int, last_space_loc+1);



{397} The fourth bullet item under "MONTHS_BETWEEN" did read:

        MONTHS_BETWEEN ('28-FEB-1994', '15-FEB-1994') ==> 0

Now reads:

        MONTHS_BETWEEN ('28-FEB-1994', '15-FEB-1994') ==> .419



{402} The last paragraph did begin with: 

        "The date component of date_entered..."

It now reads:

	"The date component of request_date..."


{403} The second to last bullet item on the page, the second code line did 
read:

        TRUNC (TO_DATE ('17-MAR-1994'), 'MM') ==> 01-APR-1994

Now reads:

        TRUNC (TO_DATE ('17-MAR-1994'), 'MM') ==> 01-MAR-1994



{415, 418, 419} Hyperbolic functions, these seem to include n, 
and h in the definitions. They should refer to n or
h (i.e. n = h, in these definitions)

Changed (h) to (n)in the code examples on those pages.




(421) The last code block on the page did begin:

        SQL> GRANT READ ON DIRECTORY projects TO SCOTT;

Now reads:

        SQL> GRANT READ ON DIRECTORY projects TO ELI;


{444} The code in the middle of the page did read:

        TO_DATE ('07-1-1994', 'FXDD-FXMM-FXYYYY') ==> 07-JUL-1994

It now reads:

        TO_DATE ('07-1-1994', 'FXDD-FXMM-FXYYYY') ==> 07-JAN-1994



{507}  In the code at the top of the page, all references to "char_format"
has been changed to "pct_stg".



{566} Combining Scalar and Aggregate Values code section did read:

  SELECT department_id, SUM (salary)
    FROM employee
ORDER BY department_id;

Now reads:

 SELECT department_id, SUM (salary)
   FROM employee
GROUP BY department_id;



{567} The first two sentences of the second to last paragraph have been 
deleted and replaced with:

        If the department does not exist, I return NULL.



{575} The code under the second bullet item has been changed to read:

SELECT TO_CHAR (note_date, 'DAY') day,
       SUM (ps_parse.number_of_atomics (text, 'urgent')) urgent_count
  FROM notes
 WHERE urgent_count > 0
 GROUP BY TO_CHAR (note_date, 'DAY');


{688} Table at bottom did read:

        WHERE type_code =

Now reads:

        WHERE typecode =


(749) The first sentence in the first paragraph has been replaced with the 
following:

        When this C function returns, the string referenced by pTimezone 
        will correspond to the current timezone as understood by the Oracle 
        extproc process executing this shared library function.

{763} In the third example of code, both:

        PACKAGE list

and

        END list;

have been changed to 

        list_pkg.

{828} The OBJ$ heading has been changed to read: OBJ#



{868} The second and third lines of code from the top have been changed to 
read:

        GROUP BY D.department_id, name;