Hierarchical queries and referential constraints
147538Jan 17 2006 — edited Jan 17 2006Experts,
What is the rationale for having a referential integrity constraint on a table that has rows bound by hierarchical relationships ?? The hierarchical relationship ensures that each row is referencing another in the same table via the PRIOR clause. If I add a foreign key relationship to these columns , does it make any sense ??/
-Rekha