Re: add dummy rows

The simple partition outer join doesn't solve the generic version of your problem.

1. On the day you switch back from DST the output should "lose" an hour - partition outer join will re-insert it (though with null data)
2. On the day with the switch if you have input values for BOTH occurrences of 2 am you're okay, but if it appears only once then partition outer won't generate the second row you need, and if 2:00 am doesn't appear at all partition outer will only generate one row of the two you need.

In passing - how are you going to get the two versions of 2:00 am in the right order on the switch ?

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

• Original Message ----- From: "Ls Cheng" <exriscer_at_gmail.com> To: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> Cc: "Oracle Mailinglist" <oracle-l_at_freelists.org> Sent: Friday, May 24, 2013 10:47 AM Subject: Re: add dummy rows

| Hi
|
| The example I posted was with test data. The real thing is that we have
| data for each hour in a day (24 rows) but when Daylight Savings Time
kicks
| in we will have 25 rows because the hour 2 is accounted twice in that
| specific day.
|
| So basically

--
http://www.freelists.org/webpage/oracle-l