Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> very quick question (really quick)
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:29:11 CDT