|
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.
|