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

Home -> Community -> Usenet -> comp.databases.theory -> Re: user defined column functions?

Re: user defined column functions?

From: Nis Jorgensen <nis_at_dkik.dk>
Date: Wed, 01 May 2002 11:36:44 +0200
Message-ID: <24dvcusbqrn9qmtefk3dh105c456en8b0g@4ax.com>


On Sat, 27 Apr 2002 11:22:40 +0200, GoranG <icmc2MAKNUTIOVO_at_pop.tel.hr> wrote:

>
>Probably why domain errors occur.
>The logic is valid, however.
>Does this work?
>
>SELECT CASE MIN(ABS(SIGN(nbr)))
> WHEN 0 THEN 0.00
> WHEN 1 THEN
> (CASE MIN(SING(nbr))
> WHEN 1 THEN EXP(SUM(LN(nbr)))
> ELSE (EXP(SUM(LN(ABS(nbr)))) *
> (CASE WHEN MOD (SUM(ABS(SIGN(nbr)-1)/2)),2) =
>1
> THEN -1.00
> ELSE 1.00 END) END)
> ELSE NULL END AS big_pi
>FROM NumberTable;

The logic seems fine to me. However there seems to be a couple of unneeded CASE statements in there

SELECT CASE MIN(ABS(SIGN(nbr)))

	WHEN 0 THEN 0.00		
	WHEN 1 THEN EXP(SUM(LN(ABS(nbr)))) *  
		(1 - MOD (SUM(SIGN(nbr)-1),4))
	ELSE 1.00 END AS big_pi -- the product of 0 numbers is 1!
FROM NumberTable;
-- 
Nis Jorgensen
Amsterdam

Please include only relevant quotes, and reply below the quoted text. Thanks
Received on Wed May 01 2002 - 04:36:44 CDT

Original text of this message

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