Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-02-2009
Member
 
Join Date: Feb 2009
Posts: 8
What is null value?

Hello friends!

Can you guys tell me what is Null value.

Regards,
Reply With Quote
  #2  
Old 13-02-2009
Member
 
Join Date: May 2008
Posts: 44
Re: What is null value?

The nullability of a column determines if the rows in the table can contain a null value for that column. A null value, or NULL, is not the same as zero (0), blank, or a zero-length character string such as ""; NULL means that no entry has been made.

A value of NULL indicates the value is unknown. A value of NULL is different from an empty or zero value. No two null values are equal. Comparisons between two null values, or between a NULL and any other value, return unknown because the value of each NULL is unknown.

In general, avoid permitting null values because they incur more complexity in queries and updates and because there are other column options, such as PRIMARY KEY constraints, that cannot be used with nullable columns.
Reply With Quote
  #3  
Old 14-02-2009
Member
 
Join Date: Dec 2007
Posts: 38
Re: What is null value?

null is a value that is unknown , unavailable or
inapplicable. Null is not same as zero or blank space.
Reply With Quote
  #4  
Old 14-02-2009
Member
 
Join Date: May 2008
Posts: 115
Re: What is null value?

Many argue that it should be allowed to have NULL values in a database. The reality is; all database systems I know of, allow NULL values for columns. But is it right; or even better; are NULL values at all allowed at all according to the relational model?

I should make you aware of the fact that the term "NULL values" is actually incorrect: NULL means "unknown", and as such, it can not be considered a "value" at all.

The relational model states that every attribute has a value for a given occurence (row/tuple). (Remember, NULL is not a value, it is something unknown). NULL means something is unknown. It does NOT mean null (the digit 0). Null (or zero, the digit) is a known value: You can include 0 in calculations, whilst NULL stands for "value is unknown". There is a world of difference between the two.

Please refer this webpage for further details:
http://www.databasedesign-resource.c...-database.html
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is null value?"
Thread Thread Starter Forum Replies Last Post
Dereferencing NULL pointer in C++ TO-Phir Software Development 4 26-06-2011 07:42 PM
Does Null value refer to empty value in SQL? Chellam Software Development 3 07-01-2011 08:24 AM
How to Check Null Value in C#? sivaranjan Software Development 4 04-02-2010 04:49 AM
How To Create A Null Modem Snake08 Networking & Security 0 12-01-2009 09:59 AM
Handling NULL in ASP.NET Techie Software Development 3 21-09-2005 06:16 PM


All times are GMT +5.5. The time now is 05:12 AM.