Insert null value to a date field

[pickle]

How do you insert a null value into a date field? I've tried to use 'null' and ' ' but there's an error. How do you do it?

Thanks in advance.

[ales]

Just use null, nothing more, nothing less:
scott@oracle> create table d (dd date);

Table created.

scott@oracle> insert into d values(null);

1 row created.

[pickle]

Thanks for the answer


:D

[bensr]

In case of nulls it is a good practice to use
explicit conversion:
insert into d values(to_date(null));