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: Guideline to save 0 or NULL to a NUMBER column

Re: Guideline to save 0 or NULL to a NUMBER column

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 17 Jun 2003 11:52:50 -0700
Message-ID: <3EEF6382.9314C55B@exxesolutions.com>


Brian Peasland wrote:

> Would you save 3 when you meant pi? Would you save 5 when you meant 12?
> Would you save 1.6180339887 or –0.6180339887 (anyone know what those two
> numbers are?) when you meant 1234567890? I wouldn't. I'd save what I
> meant to save. If I mean 5, then save 5. If I mean 3, then I'd save 3.
> If I didn't know what I meant, then I'd save NULL.
>
> Just my 3.14159265 cents worth,
> Brian
>
> <snipped>

(sqrt(5)+1)/2? ... well actually Phi.

In your spare time try this:

e raised to the power (pi * i)) + 1

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Jun 17 2003 - 13:52:50 CDT

Original text of this message

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