Re: On Update Casecade

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Wed, 22 Aug 2001 10:19:45 -0700
Message-ID: <3B83E9B1.328DE688@attws.com>

Duraiswamy wrote:

> Hi,
> How to write on-update-cascade constraint in oracle. My requirement is to
> update the value in primary key column of a table which is having references
> to many child tables. These child tables to be updated immediately after
> updating the parent table.
>
> Thanks in advance
> Duraiswamy

There is no such things as an on-update constraint. Perhaps you are referring to an on update trigger.

But you should never need to update a primary key column.

If something is requiring you to update a primary key redesign your schema or you will likely pay a very heavy price.

Daniel A. Morgan Received on Wed Aug 22 2001 - 12:19:45 CDT