Oracle SQL*Plus: The Definitive Guide
by Jonathan Gennick


This errata page lists errors outstanding in the most recent printing.  

If you have any error reports or technical questions, you can send them to
booktech@oreilly.com. (Please specify the printing date of your copy.)


This page was updated on November 22, 2000.


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


CONFIRMED errors:


(200)  In the book, I state that you can get the definition of a check 
constraint just by looking at the ALL_CONSTRAINTS table. Indeed you can. The 
definition is in the SEARCH_CONDITION column. However, what I said in the book 
may leave the impression that the ALL_CONS_COLUMNS view is irrelevant for 
check constraints.

That's not true. The ALL_CONS_COLUMNS view is still relevant. With a check 
constraint, ALL_CONS_COLUMNS can be used to identify the columns involved. It 
won't get you to the exact formula used for the check condition, but it will 
tell you which columns are used in that formula.

Thanks to Ron Joffe for bringing this very subtle issue to light.