Re: add dummy rows

  • From: Fergal Taheny <ftaheny@xxxxxxxxx>
  • To: exriscer@xxxxxxxxx
  • Date: Fri, 24 May 2013 09:46:40 +0100

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


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2013