Re: Using string variables in Select statements

okumura-mikiop_at_jvc-victor.jp 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 Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org