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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Non-updatable view with LEAD...

Re: Non-updatable view with LEAD...

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 4 Jun 2006 08:15:01 -0500
Message-ID: <ubqt8yjop.fsf@rcn.com>


On 3 Jun 2006, deanbrown3d_at_yahoo.com wrote:
> Yeah I thought about that (although I have never done an instead of
> trigger). There are 30+ other fields in this table, is there a way to
> automate these and any new fields that get added in the future?

If you use Erwin, create a macro to create the instead-of trigger. When a new column gets added to your model, recompile the instead-of trigger.

-- 
Galen Boyer
Received on Sun Jun 04 2006 - 08:15:01 CDT

Original text of this message

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