Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> delete only 1 row

delete only 1 row

From: EN <nlee_at_mediashell.net>
Date: 2000/05/30
Message-ID: <3934217A.F2FEA841@mediashell.net>#1/1

Hi,

This is a newbie question ...

For example, I'm executing the SQL statement below:

DELETE FROM my_table WHERE my_col = 3

My understanding is that every row with "my_col = 3" will be deleted. What if I only want one of those rows to be deleted?

Any help is greatly appreciated,
EN Received on Tue May 30 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US