Oracle SQL: The Essential Reference
by David C. Kreines


Following are the changes made in the 9/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

(xiii)  In the third line:

	"DDL is comprised of the verbs SELECT, INSERT, UPDATE..."  

Has been changed to:

	"DML is comprised of the verbs SELECT, INSERT, UPDATE..."


(9-10)  The date referenced in the code samples at the bottom of page 9 and
the top of page 10 did not match that mentioned in the text in the last 
paragraph on page 9 and the first paragraph on page 10. Therefore:

"07-Jul-76"

Has been changed to:

"04-Jul-76" 


(91)  First example:

There is too much space before NUMBER(2) NOT NULL.  This line should line up 
with VARCHAR2 below.  Also, third line VARCHAR should be VARCHAR2.


{92}  The ALTER TABLESPACE syntax:

	ALTER TABLESPACE tablespace_name
	   ...
	   ...
	   [RENAME 'filename1` TO 'filename2']

Has been changed to:

	ALTER TABLESPACE tablespace_name
	   ...
	   ...
	   [RENAME DATAFILE 'filename1' TO 'filename2']


{166}  Example for LPAD function:

"X YYX LEFTLEFTRIGHT"

Has been changed to:

"X YYX LEFTLEFRIGHT"


(170)  In the first RTRIM example, the 2 at the beginning of the 2nd line is 
no longer in boldface.