Brain Freeze - Request Delete Syntax Help
- From: "Buck Turgidson" <jc_va@xxxxxxxxxxx>
- Date: Fri, 29 Feb 2008 09:13:01 -0500
I need to reverse the logic of a SELECT statement, and change it into a
DELETE statement.
Do I have this right? Does this:
--------------
select * from
mytable.
where ( aggr = '1' OR ( aggr = '3' AND agg_d <> 'X' ) ).
--------------
Convert to this for a table that is loaded without the above where clause?
--------------
delete from mytable
where ( aggr <> '1' and ( aggr <> '3' AND agg_d = 'X' ) ).
--------------
.
- Follow-Ups:
- Re: Brain Freeze - Request Delete Syntax Help
- From: Doug Miller
- Re: Brain Freeze - Request Delete Syntax Help
- Prev by Date: Re: DBMS_SCHEDULER problem.
- Next by Date: Re: DBMS_SCHEDULER problem.
- Previous by thread: DBMS_SCHEDULER problem.
- Next by thread: Re: Brain Freeze - Request Delete Syntax Help
- Index(es):