Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> boolean in caluclations

boolean in caluclations

From: jobs <jobs_at_webdos.com>
Date: 29 May 2007 12:40:09 -0700
Message-ID: <1180467609.765964.202800@p47g2000hsd.googlegroups.com>


how can i do this in pl-sql?

when lines=2 that is replaced by a 1 allowing that math to take place

when lines>2 it adds the other piece instead. Trying to avoid if statements.

fee := (fixed_mf + ((lines=2)* lines_2) + (((lines>2)*(lines-1))*lines_more));

thanks for any help or information. Received on Tue May 29 2007 - 14:40:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US