Re: FK relations...

I do agree...I had to design a system for cascade updates & I used a new id column in every table where cascade updates were required and updated them using DB triggers. That's the best approach & it will be better if ORACLE can implement this internally.
Prab Athilat

Internet Coop <coop_at_greystoneapts.com> wrote in article <5f1qdk$otm_at_dnews.pbi.net>...
> I was wondering if Oracle can do an optimization so that foreign keys
> are stored as fake keys rather than the actual fields themselves.
> This way cascade updates on key fields would not need to be
> replicated. I know that this could be done manually, but if the
> database suports it, that seems like a better design way to go.
>
>
  Received on Fri Feb 28 1997 - 00:00:00 CST