Re: how to delete a date field on oracle?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 11 Jul 2002 15:19:01 GMT
Message-ID: <3D2DA1B4.BFB3B82A@exesolutions.com>

Oliver Brausch wrote:

> 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

UPDATE table_name
SET date_field = NULL
WHERE ....; Be sure you have a WHERE clause or you will wipe out every date in every record in the table.

Daniel Morgan Received on Thu Jul 11 2002 - 10:19:01 CDT