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

Home -> Community -> Usenet -> c.d.o.tools -> Oracle RDB for VMS trigger

Oracle RDB for VMS trigger

From: <summerzone_at_my-deja.com>
Date: 2000/06/06
Message-ID: <8hjja6$fvt$1@nnrp1.deja.com>#1/1

I have a table that is triggered to insert into another table. There are some fields in the first table that need to be modified in the second table if the numbers are too big or too small. My first option was to create an AFTER INSERT Trigger on the 2nd table and then update the fields with the correct information. But this seems to cause a nice performance hit. The other option would be to somehow massage the data before it gets inserted into the 2nd table. Would anyone be kind enough to enlighten me on how I could do this in ORACLE RDB 6.0 - 7.0?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jun 06 2000 - 00:00:00 CDT

Original text of this message

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