Re: Remove Date overlap duplicates
Date: Mon, 5 Oct 2009 20:26:19 +0200
"Shank..." <willbecreated_at_gmail.com> a écrit dans le message de news:
| 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