Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> create set of numbers
Hi!
This is MAYBE a true sql-question and not oracle specific.
I have the Problem to create a set of numbers between, say 1.000.000.000 and 9.000.000.000 and join it using 'minus select' against integers in an existing table in order to get the set of numbers between 1.00... and 9.000.... which are NOT in the existing Table.
To do this, do i really have to create a dummy-table and fill an integer-column completely with values from 1... to 9..... or is there an on-the-fly-way ?
Regards,
John Received on Wed Jun 09 1999 - 11:47:36 CDT