Re: Storing Equations in a Table

From: Blv n Drms <blvndrms_at_aol.com>
Date: 1995/04/29
Message-ID: <3nv1oh$fmm_at_newsbf02.news.aol.com>#1/1


Peter,

I would suggest making your equations/formula as stored functions (pl/sql) then you can use them in all of your sql statements and also list them by doing a select on the user_source table.

example:



my_formula multiplies a number by 2 and divides by the second value passed

SELECT my_formula(30, .3) FROM dual;

200


Source

Jack Richter Received on Sat Apr 29 1995 - 00:00:00 CEST

Original text of this message