Re: simulating a select returning a million rows?

#1

Michel Cadot <micadot{at}altern{dot}org> wrote:

Quote:

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

I tried searching, but couldn't come up with any results.
Now I know to call this a "row generator" and get lots
of results... thanks!

--
Mark Harrison
Pixar Animation Studios

#2

Peter Nilsson <airia (AT) acay (DOT) com.au> wrote:

Quote:

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

#3

On 07.06.2009 02:03, mh (AT) pixar (DOT) com wrote:

Quote:

Peter Nilsson <airia (AT) acay (DOT) 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!

But keep in mind that if you are investigating execution plans the mere
fact that you do not query a real table might dramatically change the
plan in question probably making the exercise useless.

Kind regards

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: simulating a select returning a million rows?

comp.databases.oracle.misc comp.databases.oracle.misc

Re: simulating a select returning a million rows? - 06-06-2009 , 07:02 PM

Re: simulating a select returning a million rows? - 06-06-2009 , 07:03 PM

Re: simulating a select returning a million rows? - 06-13-2009 , 04:59 AM