Re: Remove Date overlap duplicates

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 5 Oct 2009 20:26:19 +0200
Message-ID: <4aca3a4e$0$1451$>

"Shank..." <> a écrit dans le message de news:
| 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?

Why have you to delete the third row and changing the start date of fourth one to '01-jan-2006'?

Michel Received on Mon Oct 05 2009 - 13:26:19 CDT

Original text of this message