Re: On Update Casecade
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 22 Aug 2001 18:30:42 +0100
Message-ID: <3B83EC42.4F54_at_yahoo.com>
Date: Wed, 22 Aug 2001 18:30:42 +0100
Message-ID: <3B83EC42.4F54_at_yahoo.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
http://osi.oracle.com/~tkyte/update_cascade/index.html
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Wed Aug 22 2001 - 19:30:42 CEST