Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: very quick question (really quick)
update tableA set column=NULL where <condition>
"feeBALL" <noone_at_free.com> wrote in message
news:afsdbr$go4p2$1_at_ID-134160.news.dfncis.de...
> What is the command for deleting entries in a column (keeping the rest of
> the row) when that column matches a particular criteria?
>
> The following statement deletes the entire row:
> DELETE FROM TABLE_A
> WHERE ITEM = 'criteria';
>
> I tried this but obviously it did not work:
>
> DELETE COLUMN_A FROM TABLE_A
> WHERE ITEM = 'criteria';
>
> can someone help ?
>
>
>
>
>
Received on Tue Jul 02 2002 - 09:53:58 CDT