simulating a select returning a million rows?
From: <mh_at_pixar.com>
Date: Sun, 31 May 2009 02:08:32 GMT
Message-ID: <AElUl.30839$Ws1.15998_at_nlpi064.nbdc.sbc.com>
I have a table that has 1 million rows populated with number 1..1000000.
Date: Sun, 31 May 2009 02:08:32 GMT
Message-ID: <AElUl.30839$Ws1.15998_at_nlpi064.nbdc.sbc.com>
I have a table that has 1 million rows populated with number 1..1000000.
create table foo(x number);
I use this for testing our various client software.
select * from foo order by x;
Is there a way I can get the same select results without having to pre-populate a table?
This was all I could think of which works but might not scale... :-)
select 1 from dual union select 2 from dual union ...;
many TIA!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Sat May 30 2009 - 21:08:32 CDT