Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to write a tricky query
laredotornado_at_zipmail.com wrote:
> Hello,
> I have a list of values,
>
> ('a', 'b', 'c', 'd')
>
> and I am trying to find out which of those values is NOT in the list
> returned from this query
>
> SELECT LETTER FROM LETTER_TABLE
>
> Is there a way I can write a query to extract this information? To
> complicate things, I'm using Oralce 8 on Solaris.
>
> Thanks for your help, - Dave
Go asktom.oracle.com and search "str2tbl" Received on Tue Jun 28 2005 - 10:17:33 CDT