INSERT INTO TABLE X VALUES('ABC','DEF','')

How do you insert a record with a nullable column?

Question Posted / s

Answer Posted / s

INSERT INTO TABLE X VALUES('ABC','DEF','')

will allow you to insert a record with no value specified
for the nullable column

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the difference between oracle and db2?

1028

What are catalog tables in db2?

979

define clustering index.

976

Explain about open switch business continuity software?

1071

Name the various locking levels available?

1035

can all users have the privilage to use the sql statement select * (dml)?

1102

What is the picture clause of null indicator variable?

1080

What is a bind card?

1140

What is bind plan?

975

Is db2 a mainframe?

968

What is nvl in db2?

1039

What is the use of reorg in db2?

1023

How many databases can be created inside an instance in db2 ?

976

When the like statement is used?

1156

Explain the benefits you can get from mainframe connect?

910