You can update a field to null using the sql UPDATE command. The only
circumstance under which this will fail is if the field is defined as NOT
NULL in which case you should get a fairly informativbe error message to
this effect.
HTH
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Oliver Brausch" <ob112_at_web.de> wrote in message
news:cd11d95c.0207110110.910abf6_at_posting.google.com...
> Hello all,
> I entered a date to an oracle table and then I want to delete
> it again. (the content, means reset the date to "NULL").
> Is this possible and how?
>
> I was told that this would not be possible and I cannot
> believe it.
>
> Thanks for you help,
> Oliver
Received on Thu Jul 11 2002 - 04:28:58 CDT
