Re: Difficult Delete Rows
From: Thomas Sommerfeld <TSommerfeld_at_gmx.de>
Date: Wed, 20 Feb 2008 12:36:18 +0100
Message-ID: <fph3fv$lt$2@online.de>
Date: Wed, 20 Feb 2008 12:36:18 +0100
Message-ID: <fph3fv$lt$2@online.de>
Hi,
learning_codes_at_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.deReceived on Wed Feb 20 2008 - 05:36:18 CST