Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is This the varchar2 ZLS Issue?

Re: Is This the varchar2 ZLS Issue?

From: Tony Andrews <andrewst_at_onetel.com>
Date: 21 Mar 2006 02:49:38 -0800
Message-ID: <1142938178.066473.280490@u72g2000cwu.googlegroups.com>


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

Original text of this message

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