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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 17 Jun 2003 16:32:09 +0100
Message-ID: <3eef3479$0$18490$ed9e5944@reading.news.pipex.net>

"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

> 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"

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Jun 17 2003 - 10:32:09 CDT