Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Values depending on other values
NegreT wrote:
> Hi all,
>
> I have to insert some rows in a database and some values in this rows
> depends on the values of other rows in the database.
>
> This new value must continue up to date dependig on the value of the
> origin data.
>
> ¿How could I do this? I´ve been thinking of using triggers that update
> the variable values but, is there any other way?
>
> Thanks in advance
You should almost never store the result of a calculation in a relational database. Why not calculate the value on the fly for display on screen or in reports?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Jan 14 2004 - 04:57:13 CST