dmclaude wrote:
> All,
>
> I am trying to select from a list of ids where the ids are not in a
> table. So far all I've come up with is adding all the ids to a
> temporary table and then selecting from one where not in the other.
>
> Is there an easy (no table creation) way to do this?
>
> eg. (in pseudo code)
>
> Table Test
> id varchar (2)
> {'aa', 'cc', 'dd')
>
> List testList
> ('aa', 'bb')
>
> I want to be able to see 'bb' is in list testList but not in table
> Test.
>
> appreciate any help
> -dmclaude
>
go to asktom.oracle.com and look for "variable in list"
Received on Mon Dec 13 2004 - 12:10:33 CST
