Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 6398 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
NOT NULL disallows nulls for the column. Primary Key must
be defined as NOT NULL or any key that you do not want to
have NULLS, becaue the default is that any column can
contain NULLs
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / andank
NOT NULL is the keyword used define columns, when create a
table. When you specify NOT NULL to a column, that column
can not hold NULL values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / s
CREATE UNIQUE WHERE NOT NULL INDEX index1
ON table(column);
WHERE NOT NULL ensures that non-null values are unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the picture clause of the null indicator variable?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What are the contents of a dclmgen?
What action db2 takes when a program aborts in the middle of a transaction?
What is runstats db2?
Can we delete records from view?
Define db2 and its databases?
When do you specify the isolation level? How?
What is node in db2?
What is db2 purescale?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
select 100 records from million records ?
COBOL 
