Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Remove default value from table definition
Walt wrote:
> Looks like your demo shows how to set the default value to NULL.
>
> I'm not that this is a distinction with a difference, but the OP seems
> to think it is.
>
> //Walt
Setting it to NULL is removing it. NULL is the default. That is what it is on all Oracle tables all the time. If the user doesn't provide a value then the column, by default, is NULL.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Jan 17 2006 - 15:49:15 CST
![]() |
![]() |