Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: boolean in caluclations
"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
![]() |
![]() |