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: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 17 Jun 2003 20:26:36 +0100
Message-ID: <3eef6b13$0$10624$cc9e4d1f@news.dial.pipex.com>


"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

Original text of this message

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