Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cascade Update

Re: Cascade Update

From: <pbolduc_at_my-deja.com>
Date: Sat, 18 Sep 1999 05:57:35 GMT
Message-ID: <7rv9kb$grs$1@nnrp1.deja.com>

 The Oracle Government site used to have a package that generated cascade update pl/sql using triggers and packages. I have the code as downloaded, but have never used it. It is a 30K zip file. It is for v7. I thought in v8 there is support for cascade update?

One interesting note: the Oracle Government code has an option to preserve the rowid of the cascade update rows, although there would be a small performance hit.

Phil

In article <7rq77f$fop$1_at_news.is.co.za>,   "Nemniss" <nemniss_at_email.com> wrote:
> Hi. I need to do cascaded updates on my database. Does any one know
where
> I might find such an Utility or a script?
>
> Much Appreciated
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Sep 18 1999 - 00:57:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US