Oracle SQL*Plus: The Definitve Guide errata by Jonathan Gennick The following are the changes made in the 12/00 reprint. Here's a key to the markup: [page-number]: serious technical mistake {page-number}: minor technical mistake : important language/formatting problem (page-number): language change or minor formatting problem ?page-number?: reader question or request for clarification (xix) The text of the "How to Contact Us" section has been updated. It now reads: How to Contact Us The information in this book has been tested and verified, but you may find that features have changed (or you may even find mistakes!). You can send any errors you find, as well as suggestions for future editions, to: O'Reilly & Associates, Inc. 101 Morris Street Sebastopol, CA 95472 (800) 998-9938 (in the United States or Canada) (707) 829-0515 (international/local) (707) 829-0104 (fax) There is a web page for this book, where we list any errata, examples, and additional information. You can access this page at: http://www.oreilly.com/catalog/orsqplus/ To ask technical questions or comment on the book, send email to: bookquestions@oreilly.com For more information about our books, conferences, software, Resource Centers, and the O'Reilly Network, see our web site at: http://www.oreilly.com <25> The listvariable description for "scriptfile" did read: "Is the name of a SQL*Plus script file you want to run. SQL*Plus will start up, execute the file, and then exit." Now reads: "Is the name of a SQL*Plus script file that you want to run. Be sure to end your script with an EXIT command." (25) The last italicized heading near the bottom of the page did read: "arg1 agr2 arg3" Now reads: "arg1 arg2 arg3" [84] Deleted the COMMIT statement in the code example in the middle of the page. [85] Deleted the COMMIT statement towards the end of the large code example. (Chapter 4) All the notes and warnings in this chapter were missing their icons. Here is a list of the icons that were inserted on the relevant pages: p. 123 - owl p. 134 - owl p. 140 - owl p. 141 - both owls p. 148 - owl p. 150 - turkey p. 153 - owl <150> The first sentence in the first paragraph did read: "There are only two ways to deal with this problem." Now reads: "There are at least two ways to deal with this problem." (196) In the second line of the comment in the code sample, changed "seperate" to "separate." {216} In the first sentence under "Running the SHOW_TRIGGER.SQL script," changed "TEST_1" to "EMP_HIRE_DATE_CHECK". {239} In the 11th line of the 2nd code sample, changed "prompt" tp "PROMPT". {348} In the code line "ARCHIVE LOG START [TO destination]" the closing bracket is now in regular cw, not cw italic. {382} The first sentence in the fifth paragraph on the page, under the "SET TRIMSPOOL" heading, did read: "...you will want to leave TRIMSPOOL ON." Now reads: "... you will want to leave the TRIMSPOOL OFF." (424) The last italicized heading near the bottom of the page did read: "arg1 agr2 arg3" Now reads: "arg1 arg2 arg3" (482) About 2/3 down right-hand column, changed the entry "commenting scrips" to "commenting scripts." (482) About 2/3 down right-hand column, the entry "COMMIT statement, disabling feedback from" now includes page 84. (503) In the 3rd paragraph under "About the Author," changed "Lansing, Michigan" to "Munising, Michigan."