SEO

#1 (**permalink**) 02-26-2008, 07:53 AM

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

#2 (**permalink**) 02-26-2008, 07:53 AM

Hi,

learning_codes@hotmail.com schrieb:
>
> - - - Delete From (Select * From DATATable Where
> DATATable.MonthEnd like '11-Feb-02');

try
delete from DATATable where MonthEnd = to_date('11-Feb-02', 'DD-MON-YY');

Best regards
Thomas

--
For answers by personal mail use: thomas.sommerfeld at domain ust-gmbh.de

#3 (**permalink**) 02-26-2008, 07:53 AM

On 20 Feb, 11:20, "learning_co...@hotmail.com"
<learning_co...@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/B...b14200/toc.htm

HTH

-g

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Difficult Delete Rows