Re: very quick question (really quick)

From: Christian GILBERT <externe.gilbert_at_francetelecom.com>
Date: Tue, 02 Jul 2002 15:35:47 GMT
Message-ID: <1104_1025624147@10.193.118.17>

Sur Tue, 2 Jul 2002 16:29:11 +0200, "feeBALL" <noone_at_free.com> a écrit:
> 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 ?
>

This is not a delete command that you need, but an update.

Christian GILBERT
SNPI DTO/SGBD Oracle
01 55 88 41 21 Received on Tue Jul 02 2002 - 10:35:47 CDT