Getting NON-existing data

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 Tue Jun 22 1999 - 03:53:02 CDT