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

> "Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message
> news:3EEF2897.63ED03AA_at_remove_spam.peasland.com...
> > 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?)
>
> The first one is the Golden Ratio IIRC - haven't a clue for the second

They are both the Golden Ratio. The Golden Ratio is 1/2 plus or minus the square root of five divided by two (0.5+-((5)^0.5)/2).  

> > If I didn't know what I meant, then I'd save NULL.
>
> You will clearly never make it as an end-user then? You broke the golden
> rule
>
> "Just because I don't know what I am doing won't ever stop me from doing it.
> Repeatedly"

I'm a DBA, therefore I know more than the end user! ;) LOL!!!!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"