Re: simulating a select returning a million rows?
From: <mh_at_pixar.com>
Date: Sun, 07 Jun 2009 00:03:07 GMT
Message-ID: <%sDWl.28210$c45.1002_at_nlpi065.nbdc.sbc.com>
Peter Nilsson <airia_at_acay.com.au> wrote:
> Malcolm Dew-Jones wrote:
> > select rownum from dual connect by rownum <= 1000000
>
> More common is...
>
> select level from dual connect by level <= 1000000
Date: Sun, 07 Jun 2009 00:03:07 GMT
Message-ID: <%sDWl.28210$c45.1002_at_nlpi065.nbdc.sbc.com>
Peter Nilsson <airia_at_acay.com.au> wrote:
> Malcolm Dew-Jones wrote:
> > select rownum from dual connect by rownum <= 1000000
>
> More common is...
>
> select level from dual connect by level <= 1000000
Both of these are working perfectly for me... thanks to both of you!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Sat Jun 06 2009 - 19:03:07 CDT