Triggers
From: <flavoue_at_my-deja.com>
Date: 1999/10/01
Message-ID: <7t2gnk$6m$1_at_nnrp1.deja.com>#1/1
Date: 1999/10/01
Message-ID: <7t2gnk$6m$1_at_nnrp1.deja.com>#1/1
Hi,
Here is my problem :
[Quoted] I have one table that I would like to update automatically.
I used triggers to do that but it doesn't work.
Table :
ID_objet Attribute Value
A Z1 12 A Z2 10 A Z3 120 (12*10) B Z1 5 B Z2 3 B Z3 15 (5*3)
I would like to calculate automatically the values 120 and 15 each time
I insert an object
X with the attributes Z1 and Z2.
The help documentation of oracle says that I have to create 2 triggers,
one (type : for each row) that insert in a temporary temble the value
of the product and
one that update (type : for statement) the table. The second doesn't
work.
Does any body know why?
Thank you a lot for your help.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 01 1999 - 00:00:00 CEST