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: Greg Forestieri <gforestieri9_at_yahoo.com>
Date: 18 Jun 2003 05:02:37 -0700
Message-ID: <6a8cdd95.0306180402.4acf6134@posting.google.com>


yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote in message news:<3eee32a9_at_news.victoria.tc.ca>...
> Andrew (andyho99_at_yahoo.com) wrote:
> : Is that any guideline to either save 0(zero)or NULL to a NUMBER
> : column?
>
> Yes, save the correct value - i.e. the value that correctly reflects the
> measurement to which the number refers.
>
> If you have no measurement then that is NULL, otherwise you save the
> measurement (which is 0 when it is 0).

Dead-on absolutely correct. Received on Wed Jun 18 2003 - 07:02:37 CDT

Original text of this message

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