Re: Integrity constraints with type inheritance

By creating your table my_table as of type base_typ, you stop yourself from being able to apply constraints referring to attributes of d1_typ only. According to Oracle (and any other OO languages), your variable "f2" does not even exist in the context of my_table. I therefore don't think that what you're trying to achieve is possible. I know it's not practical, but you'll have to define your tables of the type at the bottom of the hierarchy tree if you want to define constraints accessing variables only at the bottom of the tree. If you constantly expand on your hierarchical tree, go back to the drawing board and re-think your design approach.

Daniel Received on Wed Sep 10 2003 - 20:35:07 CEST