Re: add dummy rows

From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Fri, 24 May 2013 09:46:40 +0100
Message-ID: <CAOuMUT5+BbDCwYemTYRFs4qv-Cjm3tRcTTmS_NtS4xHJ31KCGg_at_mail.gmail.com>

Hi,
If you left outer join your resutset to a table or view which returns the numbers 1 to 8 then you'll get the dummy records you want. Do the join using the c1 col.

And you can generate the view using the connect by rownum less than trick

Regards,
Fergal

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

Received on Fri May 24 2013 - 10:46:40 CEST