Re: SQL query help

Guido,
thanks for responding. I don't want to use perl scripts. When you say
external tables, you mean like 'temp tables'?
I dont want to insert or create any new rows either...
any way out?
Thanks again.


"Guido Konsolke" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Joe" <[EMAIL PROTECTED]> wrote...
> > I have a list of 100 SSNs, say. There is a table that stores SSNs.
> this
> > table has 60 of the 100 SSNs.
> > Is it possible to write a query that gives me the 40 SSNs that are
> not
> > there - without using temp tables/inserts in to any table and
> without
> > writing PL/SQL(meaning without writing to files/using looping
> constructs
> > etc.).
> > I want to avoid getting the 60 SSNs that are there in the table,
> bumping it
> > up against the 100 using other tools..
> >
> > It all boils down to : how to convert a comma-seperated list to a
> record
> > set/query output using just a query ?
> >
> > Any pointers will be greatly appreciated...
> >
> > Thanks.
> >
>
> Hi Joe,
>
> external tables come to mind. Or maybe a perl script could help.
> Since you don't want PL/SQL, UTL_FILE is no option.
>
> hth,
> Guido
>
>