Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!83.128.0.11.MISMATCH!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!newsfeed2.telusplanet.net!newsfeed.telus.net!flph200.ffdc.sbc.com!prodigy.net!flph199.ffdc.sbc.com!prodigy.com!flpi107.ffdc.sbc.com!nlpi065.nbdc.sbc.com.POSTED!22f23b6c!not-for-mail Sender: Mark Harrison From: mh@pixar.com Subject: Re: simulating a select returning a million rows? Newsgroups: comp.databases.oracle.misc References: <4a23337a$1@news.victoria.tc.ca> User-Agent: tin/1.9.1-20060409 ("Benmore") (UNIX) (Linux/2.6.18-1.2200p7 (x86_64)) Lines: 15 Message-ID: <%sDWl.28210$c45.1002@nlpi065.nbdc.sbc.com> NNTP-Posting-Host: 138.72.131.96 X-Complaints-To: abuse@prodigy.net X-Trace: nlpi065.nbdc.sbc.com 1244332987 ST000 138.72.131.96 (Sat, 06 Jun 2009 20:03:07 EDT) NNTP-Posting-Date: Sat, 06 Jun 2009 20:03:07 EDT Organization: at&t http://my.att.net/ X-UserInfo1: TSUGWXCEGBTQB_H]]RKB_UDAZZ\DPCPDLXUNNHLIWIWTEPIB_NVUAH_[BL[\IRKIANGGJBFNJF_DOLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA@X_DCBHXR[C@\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^@SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN Date: Sun, 07 Jun 2009 00:03:07 GMT Xref: news.cambrium.nl Peter Nilsson 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 Studios