Re: dummy value?

From: joel garry <joel-garry_at_home.com>
Date: Tue, 20 Apr 2010 17:30:00 -0700 (PDT)
Message-ID: <aafdcd32-a714-4f4c-bff7-50b6f04213fa_at_n11g2000prh.googlegroups.com>



On Apr 20, 3:07 pm, okey <oldyor..._at_yahoo.com> wrote:
> I have large list I use in an 'IN' clause
>
> select * from mytable where x in { HUGE LIST }
>
> What I want to do is find all the entries in that huge list that do
> not match.  Some how I have to get the list value into a variable.
> Can that be done?
>
> select var from mytable where var putinvar { HUGE LIST }
> and var <> field
>
> This has to be easy to do... it just ain't click'n
>
> Thanks for your help.

One discussion: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:210612357425

jg

--
_at_home.com is bogus.
http://www.signonsandiego.com/news/2010/apr/20/two-brokers-plead-guilty-in-foreclosure-scam/
Received on Tue Apr 20 2010 - 19:30:00 CDT

Original text of this message