How do you insert a record with a nullable column?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various isolation levels possible?

892


What is db2 optimizer?

1022


What is a bind card?

937


What does db2 plan contain?

789


Mention the different locking levels that are available in db2.

896


Who uses db2?

805


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

878


What is the difference between bind and rebind in db2?

1222


What is the difference between dbm cfg and db cfg file in db2 ?

1299


How do I optimize a query in db2?

859


i want to maintain uniqueness on pdf without make lf??????????

1933


How is a typical db2 batch pgm executed?

904


Mention the downsides of page level lock.

951


What is the reason behind not using select * in embedded sql programs?

877


What is host variable?

844