Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Guideline to save 0 or NULL to a NUMBER column
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
![]() |
![]() |