Re: Deleting children, grandchildren, etc.

  • From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Oct 2006 10:31:15 -0600

I'm not familiar with the connect by, but I'll see what I can come up with.
At this point, it looks like redoing all the constraints might be the way to
go since not all child tables use the companyid as the foreign key.  Same
applies to the grandchildren, great-grandchildren, and
great-great-grandchildren.  Of course, then I have to remember to reset all
the constraints to their original form so the application doesn't do
something it shouldn't.

Thanks for your suggestions.

Sandy

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006