Remove Date overlap duplicates
From: Shank... <willbecreated_at_gmail.com>
Date: Sun, 4 Oct 2009 23:11:14 -0700 (PDT)
Message-ID: <22c647e6-f687-4ea1-9991-9fc9102fe760_at_x6g2000prc.googlegroups.com>
Hi,
Date: Sun, 4 Oct 2009 23:11:14 -0700 (PDT)
Message-ID: <22c647e6-f687-4ea1-9991-9fc9102fe760_at_x6g2000prc.googlegroups.com>
Hi,
I have a table containing following data.
ID Start_date End_date 1 20-OCT-2005 31-DEC-2005 1 01-NOV-2005 31-JAN-2006 2 01-JAN-2005 31-JAN-2005 2 01-JAN-2005 31-DEC-2006
Now I need to update the start date of 2nd Row as '01-jan-2006' and I
also need to delete the 3rd row.
In a nut shell, I need to remove the duplicate data either by updating
or by deleting.
Is there any way to do it using PL/SQL?
Received on Mon Oct 05 2009 - 01:11:14 CDT