Re: simulating a select returning a million rows?
From: Peter Nilsson <airia_at_acay.com.au>
Date: Mon, 1 Jun 2009 21:39:21 -0700 (PDT)
Message-ID: <ed213fdf-1876-459a-9bbb-51b8fb91dd73_at_l12g2000yqo.googlegroups.com>
Malcolm Dew-Jones wrote:
> select rownum from dual connect by rownum <= 1000000
Date: Mon, 1 Jun 2009 21:39:21 -0700 (PDT)
Message-ID: <ed213fdf-1876-459a-9bbb-51b8fb91dd73_at_l12g2000yqo.googlegroups.com>
Malcolm Dew-Jones wrote:
> select rownum from dual connect by rownum <= 1000000
More common is...
select level from dual connect by level <= 1000000
-- PeterReceived on Mon Jun 01 2009 - 23:39:21 CDT