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

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

Andrew wrote:
>
> Is that any guideline to either save 0(zero)or NULL to a NUMBER
> column? I personal prefer saving NULL to database to save space on a
> large table. Some people seem prefer saving 0. Is this just a personal
> choice or there is some guideline we better follow. Thanks.

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

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"