Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> create set of numbers

create set of numbers

From: Johann Höchtl <big.john_at_bigfoot.com>
Date: Wed, 09 Jun 1999 18:47:36 +0200
Message-ID: <375E9AA8.ADBF0A50@bigfoot.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US