Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Non-updatable view with LEAD...
dean 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? > > > DA Morgan wrote: >> dean wrote:
>> Use an instead-of trigger. >> >> Demo at www.psoug.org in Morgan's Library under INSTEAD-OF TRIGGER. >> -- >> Daniel A. Morgan >> University of Washington >> damorgan_at_x.washington.edu >> (replace x with u to respond) >> Puget Sound Oracle Users Group >> www.psoug.org
Other than Galen's suggestion ... no. But then any modifications to your production schema should include a tested upgrade script that replaces the trigger.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Jun 04 2006 - 12:51:53 CDT