From: summerzone@my-deja.com
Subject: Oracle RDB for VMS trigger
Date: 2000/06/06
Message-ID: <8hjja6$fvt$1@nnrp1.deja.com>#1/1
X-Http-Proxy: 1.0 PROXY1, 1.0 x72.deja.com:80 (Squid/1.1.22) for client 199.66.1.5
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Jun 06 19:27:23 2000 GMT
X-MyDeja-Info: XMYDJUIDsummerzone
Newsgroups: comp.databases.oracle.misc
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)


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.