RE: add dummy rows

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 24 May 2013 08:51:32 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D90D285E_at_exmbx06.thus.corp>

First you'll have to explain how any code is supposed to understand that c1 = 2 is a special case and is the only value on 25th that should get two rows ? I assume that you need a generic solution for an arbitrary set (or at least pair) of dates.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Ls Cheng [exriscer_at_gmail.com] Sent: 24 May 2013 09:20
To: Oracle Mailinglist
Subject: add dummy rows

MAY I must have 7 rows, and 25 of MAY 7 rows. The result should look like: *

        C1 C2 MYDATE C1_AUX

---------- ---------- --------- -----
         1        100 24-MAY-13 1
         2        200 24-MAY-13 2
         2        201 24-MAY-13 2
         3        300 24-MAY-13 3
         4        400 24-MAY-13 4
                                5
         6        600 24-MAY-13 6
                                7
         1        150 25-MAY-13 1
         2        250 25-MAY-13 2
                                2
         3        350 25-MAY-13 3
         4        450 25-MAY-13 4
         5        550 25-MAY-13 5
                                6
         7        750 25-MAY-13 7*

Anyone know how to accomplish this :-?-- http://www.freelists.org/webpage/oracle-l Received on Fri May 24 2013 - 10:51:32 CEST