Re: Getting NON-existing data

From: Dante <dnotari_at_my-deja.com>
Date: Tue, 22 Jun 1999 11:03:25 GMT
Message-ID: <7knqhp$5v7$1@nnrp1.deja.com>

Niek,
you could use a SEQUENCE

you could use ROWNUM of any of the static views (eg. ALL_OBJECTS). SELECT ROWNUM FROM ALL_OBJECTS; Regards
Dante

In article <376F4EEE.1383_at_nob.nl>,
Niek Kerkemeijer <Niek.Kerkemeijer_at_nob.nl> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 06:03:25 CDT