Re: Removing a default value

From: Jens Lenge <spampot_at_gmx.net>
Date: 29 Aug 2006 10:51:16 -0700
Message-ID: <1156873876.870883.98560@i3g2000cwc.googlegroups.com>

Michel Cadot wrote:

> What is the difference between no default and default null?
> When there is no default and you don't give a value to a field then
> this field is null.
> In Oracle, to remove a default value you set the default to null.

At least Oracle SQL Developer seems to spot a difference: Columns with no default value are displayed with an empty field in the "Data Default" column, while columns that have explicitly been set (or modified) to "default null" are displayed with "null". Also, the automatically created DDL sequence for the respective table contains "DEFAULT NULL" in the latter case while it has no default statement at all in the first case.

That's why I suspected that Oracle does make a difference between "no default" and "default to null". Or is it just a bug of SQL Developer?

Jens Received on Tue Aug 29 2006 - 12:51:16 CDT