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
- 9475 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
Explain about rct.
Describe major components of db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the use of runstats in db2?
Why do we use cursor?
How do I delete a column in db2?
What is a db2 table?
What is database reorganization?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the role of the data page in the db2 database?
How many types of page locks can be held in db2?
What is the use of value function?
Explain the function done by data manager?
How to check table size in db2 sap?
Which component is responsible for processing sql statements and selecting access paths?
