pl/sql Question

From: Harsh Kohli <harshkohli007_at_yahoo.com>
Date: 23 Apr 2003 13:00:32 -0700
Message-ID: <9173b8d7.0304231200.22ed311d_at_posting.google.com>

[Quoted] [Quoted] I have to compute a value within pl/sql using a formula stored in another user table so that user's can change the formula without changing the code. The formula looks like : [SH1 value +SH2 value)/TOT1 * 100 * W1] + [SH3 value+SH4 value)/TOT2 * 100 * W2] + [SH5 value+SH6 value)/TOT3 * 100 * W3] + ......

where SH* Value comes from a table which has the following 2 columns : SH Code SH Value

example :

SH1      94
SH2     198
SH3     218
SH4     782

.....

The TOT* and W* comes from 2 different tables.

What is the best way to store this formula in a table and how can I execute with pl/sql? Received on Wed Apr 23 2003 - 22:00:32 CEST