Re: add dummy rows
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "Oracle Mailinglist" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 May 2013 14:10:12 +0100
The simple partition outer join doesn't solve the generic version of your
problem.
a) 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)
b) 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@xxxxxxxxx>
To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: "Oracle Mailinglist" <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
