Generating a list of numbers?

From: Benjamin Johnston <s355171_at_student.uq.edu.au>
Date: 10 Oct 2002 19:18:13 -0700
Message-ID: <cf5dfa16.0210101818.1b356574_at_posting.google.com>


Hi,

Is there any trick to generate a sequence of numbers in SQL, in Oracle?

eg.
select p.id, r.value
from person p, (1 .. p.children) r

where (1 .. p.children) would be a table with p.children records

I don't want to specify an upper bound, so populating a table with natural numbers probably is out of the question.

-Benjamin Johnston
s355171_at_student.uq.edu.au Received on Fri Oct 11 2002 - 04:18:13 CEST

Original text of this message