Re: simulating a select returning a million rows?

<mh_at_pixar.com> a écrit dans le message de news: 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 Studios

Row generator is one of the most asked questions. Please search before posting.

Regards
Michel Received on Sun May 31 2009 - 01:15:34 CDT