Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is This the varchar2 ZLS Issue?
Tim Marshall wrote:
> Frank van Bortel wrote:
>
> > BTW: Why should a column never be NULL? A tuple may well
> > be undefined at a certain time (e.g. number of children
> > while status='SINGLE' - although some people... but that
> > is entirely OT), but become meaningful at a later stadium.
>
> You know, I'm not 100% certain, but the database theory folks said
> indexes are better utilized, which sounded plausible to me.
In any case, surely someone with no children should have 0 (zero) in number_of_children, not NULL! Received on Tue Mar 21 2006 - 04:49:38 CST