Interested to Buy Any Domain ? << Click Here >> for more details...
What is a NULL value? What are the pros and cons of using
NULLS?
- 2 Answers
- 9653 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
NULL Value indicates the absence of a value. DB2 treats
NULL as an actual value and is not equal to blank, zero or
empty string.
The default value of a CHAR data type is blanks, VARCHAR is
empty string and INT,SMALLINT,FLOAT etc is 0.
NULL is not equal to any of the above.
NULLs does not satify any condition in the SQL except when
IS NULL predicate is used. Null can be used at times when
you cannot specify a value for a column, eg middle names,
not everyone has middle names.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Discuss about db2 bind?
Is db2 relational database?
How do you pull up a query which was previously saved in qmf?
What is iseries database?
What is sqlca?
How to find primary key of a table in db2?
What is bind in db2?
How to find the maximum value in a column in the db2 database?
How many types of page locks can be held in db2?
What is copy pending status in db2?
When the like statement is used?
How to fetch the last row from the table in SQL (db2)?
What is the difference between dbm cfg and db cfg file in db2 ?
Is db2 a programming language?
Explain correlated sub-queries.
