Using SQL IN predicate in PL/SQL

From: R Chin <rchin_at_panix.com>
Date: Thu, 28 Feb 2002 11:36:53 -0500
Message-ID: <a5lmbp$kc9$1_at_reader2.panix.com>

[Quoted] [Quoted] In PL/SQL I have constructed a variable (called v_Pool) with the value ('ABC','DEF','GHI') to be used in the where clause of dynamic sql

The following code does not work...please help

if v_test IN v_Pool then
........;
end if;

Thanks

Robert Received on Thu Feb 28 2002 - 17:36:53 CET