View Review Details


Book:   Oracle SQL*Plus: The Definitive Guide
Subject:   Oracle SQL*Plus: The Definitive Guide Review
Date:   1999-07-25 00:00:00
From:   Ron Joffe


Great book, one of those that's always left open on my desk.


Thanks for making the sample code available,
running things through, really make the ideas sink in better


A few comments / corrections:


Page 186
Table 6-4 Columns in the ALL_CONSTRAINTS View


For the CONSTRAINT_TYPE, the contents is missing:
U = UNIQUE KEY


Page 200
Table Constraints


Sorry to be picky about this one, but :)


You State that :
ALL_CONSTRAINTS return one row for each constraint
, and is the only view you need to look at for the
definition of a check constraint.


Technically this is correct, becuase even if you
define a check constraint for a particular column
it can be coded as either a column constraint or
a table constraint, but without parsing the
search_condition column you can not obtain which
columns are affected.


Thanks for a great resource.



See larger cover
Browse within this book