Re: SQL help

ndpace_at_gmail.com wrote:

> I am creating a package for Oracle 8i. I need to pass a variable in
> and use that in the SQL statement IN clause. This worked for a simple
> equal statement but not for the IN.
>
> 'select * from CUSTOMERS where CUSTOMERS_CODE in (:x1) ' USING IDS;
>
> where IDS is VARCHAR2 and = 999,1000
>
> Thanks in advance

http://www.psoug.org
click on Morgan's Library
click on Conditions
scroll down to the "COMPLEX IN" Demo

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)