Inserting-Nulls Mode

When inserting a row in a database table, the row can contain one or more NULL values.

Here is an example of the SQL statement when the ADDRESS of employee Williams is NULL and the insert-nulls property is enabled:

INSERT INTO EMP(ID, NAME, ADDRESS) VALUES(7, ‘Williams’, NULL)

Alternatively, the following example shows the SQL statement when the insert-nulls property is disabled:

INSERT INTO EMP(ID, NAME) VALUES(7, ‘Williams’)

Version 5.7