Re: Difficult Delete Rows
From: gazzag <gareth_at_jamms.org>
Date: Wed, 20 Feb 2008 04:52:34 -0800 (PST)
Message-ID: <0a80472e-4da8-4515-9cdd-5b95e1a4ccd2@s37g2000prg.googlegroups.com>
Date: Wed, 20 Feb 2008 04:52:34 -0800 (PST)
Message-ID: <0a80472e-4da8-4515-9cdd-5b95e1a4ccd2@s37g2000prg.googlegroups.com>
On 20 Feb, 11:20, "learning_co..._at_hotmail.com"
<learning_co..._at_hotmail.com> wrote:
> Hi,
>
> I'm not sure if I did the right things to delete the records by using
> SQL Developer program.
>
> I use SQL:
>
> - - - Delete From (Select * From DATATable Where
> DATATable.MonthEnd like '11-Feb-02');
>
> MonthEnd is a date format.
>
> Your help would be much appreciated.
>
> Thanks
The relevant documentation will help you: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
HTH -g Received on Wed Feb 20 2008 - 06:52:34 CST