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: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 16 Jun 2003 14:12:09 -0800
Message-ID: <3eee32a9@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). 
Received on Mon Jun 16 2003 - 17:12:09 CDT












Original text of this message













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