Oracle SQL*Plus: The Definitve Guide errata
by Jonathan Gennick


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



<xix> The following information was added the preface:

	"How to Contact Us

	We have tested and verified the information in this book to
	the best of our ability, but you may find that features have
	changed (or even that we have made mistakes!). Please let us
	know about any errors you find, as well as your suggestions
	for future editions, by writing to:

		O'Reilly & Associates, Inc.
		101 Morris Street
		Sebastopol, CA 95472
		1-800-998-9938 (in the U.S. or Canada)
		1-707-829-0515 (international/local)
		1-707-829-0104 (FAX)

	You can also send us messages electronically. To be put on
	the mailing list or request a catalog, send email to:

		info@oreilly.com

	To ask technical questions or comment on the book, send
	email to:

		bookquestions@oreilly.com

	We have a web site for the book, where we'll list examples,
	errata, and any plans for future editions. You can access
	this page at:

		http://www.oreilly.com/catalog/orsqplus/

	For more information about this book and others, see the
	O'Reilly web site:

		http://www.oreilly.com"


?57? In chapter 2 (page 57), I told you that you could customize
the SQL*Plus editor, and referred you to chapter 11 for more
information. Unfortunately, I didn't put that information in chapter
11. I apologize for that oversight.

SQL*Plus uses the user variable named _EDITOR to point to the
executable to be invoked in response to the EDIT command. Under
Windows 3.1/95/NT/98/2000/whatever, the default setting is "NOTEPAD".
You can change this value to point to any editor you like. The
following example sets the editor to WordPad

        define _editor="C:\PROGRA~1\ACCESS~1\WORDPAD.EXE"

The DEFINE command only changes the setting for the current session.
To make the setting permanent, place the DEFINE command in your
login.sql file. That way it will be executed each time you start
SQL*Plus. Chapter 11 in the book contains more information about
login.sql

The last sentence currently used to read:

        "Chapter 11 tells you how to do this."

Now reads:

        "Do this by defining the user variable named _EDITOR to
        point to executable of the editor you want to use."


{183} In the left column of Table 6-2, near the bottom of the page,
it read:

        NUM_ROW 

Now reads:

        NUM_ROWS


{186} In Table 6-4, "U = UNIQUE KEY" has been added to the contents
column for the CONSTRAINT_TYPE field.


<504> The following RepKover information was added to the Colophon:

	Whenever possible, our books use RepKover(TM), a durable and
	flexible lay-flat binding. If the page count exceeds RepKover's
	limit, perfect binding is used."