Re: Removing a default value

Michel Cadot wrote:
> "Jens Lenge" <spampot_at_gmx.net> a écrit dans le message de news: 1156881318.101082.89180_at_i42g2000cwa.googlegroups.com...
> | Michel Cadot wrote:
> |
> | > It's not a bug.
> | > The difference is due to Oracle dictionary.
> | > [...]
> | > But there is no *functional* difference between nothing the default
> | > value or a default of "null" (without any king of quote).
> |
> | Ok, thanks for the explanation. I understand that it is not a
> | functional difference (and therefore a rather theoretical question),
> | but just to complete my files:
> | Does Oracle provide a way to remove a default value setting so that the
> | dictionary entry is also reset to null (instead of "null")? Just like
> | there has never been any default value?
> |
> | Jens
> |
>
> No.
>
> Regards
> Michel Cadot

I agree with Michel and Andy that Oracle does not provide any supported set of commands you can issue to clear this. To make the dictionary appear as if there had never been an explicit default value specified then the table would have to be dropped and recreated without specifiying an explicit default on the column in question.

HTH -- Mark D Powell -- Received on Wed Aug 30 2006 - 11:40:04 CDT