Oracle PL/SQL Programming: Guide to Oracle 8i Features
by Steven Feuerstein


This page contains changes made in the 10/00 printing.


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


<226>  The following item has been added to the bulleted list at the top of 
the page:

        "* The trim_char may consist of only a single character."

Also, all references to "trim_chars" in the section "The TRIM Funtion" on 
pages 225-226 have been changed to "trim_char."



[226]  The code sample on this page did read:

*****************
DECLARE
   mystr VARCHAR2(10);
   yourstr VARCHAR2(10) := 'Toronto';
BEGIN
   DBMS_OUTPUT.PUT_LINE (
      TRIM (LEADING 'x' FROM 'xyzabc'));
   DBMS_OUTPUT.PUT_LINE (
      TRIM (TRAILING 'cb' FROM 'xyzabc'));
   DBMS_OUTPUT.PUT_LINE (
      TRIM (BOTH 'x1' FROM '1x1yzabc111x'));
   DBMS_OUTPUT.PUT_LINE (
      TRIM ('x1' FROM '1x1yzabc111x'));
   DBMS_OUTPUT.PUT_LINE (
      TRIM (mystr FROM yourstr));
END;
/
*****************

Now reads:

*****************
DECLARE
    mystr VARCHAR2(10);
    yourstr VARCHAR2(10) := 'Toronto';
BEGIN
    DBMS_OUTPUT.PUT_LINE (
       TRIM (LEADING 'x' FROM 'xyzabc'));
    DBMS_OUTPUT.PUT_LINE (
       TRIM (TRAILING 'c' FROM 'xyzabcccc'));
    DBMS_OUTPUT.PUT_LINE (
       TRIM (BOTH 'x' FROM 'x1yzabc111x'));
    DBMS_OUTPUT.PUT_LINE (
       NVL (TRIM (mystr FROM yourstr), 'NULL'));
END;
/
*****************