Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Guideline to save 0 or NULL to a NUMBER column
"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message
news:3EEF4D39.6D3C0475_at_remove_spam.peasland.com...
> > "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).
Didn't know that. I know the Golden ratio from Architecture and Nature and have difficulties seeing where the negative comes in.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Tue Jun 17 2003 - 14:26:36 CDT
![]() |
![]() |