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 -> Re: boolean in caluclations

Re: boolean in caluclations

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 30 May 2007 06:35:37 +0200
Message-ID: <465cff18$0$22345$426a74cc@news.free.fr>

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1180467609.765964.202800_at_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.
|

(lines = 2) returns TRUE or FALSE.
How can you multiply that by lines_2?

What should be the result of 2*TRUE?

Regards
Michel Cadot Received on Tue May 29 2007 - 23:35:37 CDT

Original text of this message

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