Re: Getting NON-existing data

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Thu, 24 Jun 1999 19:28:52 GMT
Message-ID: <UFvc3.47090$Fz2.6051@news.rdc1.az.home.com>

This would work, although it's ugly...

SELECT 1 FROM DUAL
UNION
SELECT 2 FROM DUAL
UNION
SELECT 3 FROM DUAL
UNION
etc....

C. <c_ferguson_at_rationalconcepts.com> wrote in message news:3771D984.366236C5_at_rationalconcepts.com...
> Hi,
> Create a sequence.
> C. Ferguson, Rational Concepts.
>
> Niek Kerkemeijer wrote:
>
> > Hi,
> >
> > I have a nice question:
> > I need oracle to generate a number-range for me without having
> > a table containing these values.
> >
> > Example:
> > I have an empty database (there are no tables in it) and I need
> > a query which results in the following:
> >
> > +------+
> > | id |
> > +------+
> > | 1 |
> > | 2 |
> > | 3 |
> > | 4 |
> > | 5 |
> > | 6 |
> > | 7 |
> > | 8 |
> > | 9 |
> > | 10 |
> > +------+
> >
> > Any ideas?
> >
> > Niek.
>
>
Received on Thu Jun 24 1999 - 14:28:52 CDT