Is there a way to generate list of missing dates in table in Oracle? Input name,my_date A,04-JAN-2000 A,05-JAN-2000 A,08-JAN-2000 A,08-JAN-2000 — duplicates possible A,10-JAN-2000 B,09-FEB-2001 B,10-FEB-2001 B,05-FEB-2001 Result A,06-JAN-2000 A,07-JAN-2000 A,09-JAN-2000 B,06-FEB-2001 B,07-FEB-2001 B,08-FEB-2001 After suggestion from @diiN__________ to see Oracle: select missing dates, I managed to get it working for a specific name as… Read More SQL to identify missing dates in column