Re: Using string variables in Select statements

okumura-mikiop@[EMAIL PROTECTED]
 wrote:
> I am attempting to use a variable in the WHERE clause of a SELECT
statement.
> How would one pass a value for an IN statement, ie.
> 
> 	SELECT *
> 	FROM inventory
> 	WHERE color IN ('red','green')
> 
> If I replaced the last line with
> 
>         WHERE color IN (v_color)
> 
> How would I set it?
> 
> v_color := '"red","green"'
> 
> doesn't work.

There is a demo of how to do it in Morgan's Library at www.psoug.org
Click on Morgan's Library under Resources on the left.
Click on Conditions
Scroll down to "Complex IN Demo."

Some of what it demos is what does NOT work so run the complete demo
and then use what works.
-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org