Re: add dummy rows

From: Ls Cheng <exriscer_at_gmail.com>
Date: Fri, 24 May 2013 10:51:31 +0200
Message-ID: <CAJ2-Qb-8kA1GG6pk5--OCJVpuGPVpuE=RyufTqKW34hwyRrXUA_at_mail.gmail.com>

Hi Fargal
I already tried that but it doesnt work,

select * from t4, (select level rn from dual connect by rownum < 8) b where t4.c1(+) = b.rn
order by mydate, c1

• C1 C2 MYDATE RN ---------- ---------- --------------- ---------- 1 100 20130524 093719 1 2 200 20130524 093719 2 2 201 20130524 093719 2 3 300 20130524 093719 3 4 400 20130524 093719 4 6 600 20130524 093719 6 1 150 20130525 093652 1 2 250 20130525 093652 2 3 350 20130525 093652 3 4 450 20130525 093652 4 5 550 20130525 093652 5 7 750 20130525 093652 7
  *
  *
  *
  *Because in t4 I have all the numbers in the dual generated rows.
  *
  *
  *
  *I need to generate 1, 2, 2, 3, 4, 5, 6, 7 not from 1 to 8 as well.
  

*

Thanks*
*

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

Received on Fri May 24 2013 - 10:51:31 CEST