Re: Using string variables in Select statements

From: DA Morgan <>
Date: Thu, 01 May 2008 09:30:22 -0700
Message-ID: <> 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.
> 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 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu May 01 2008 - 11:30:22 CDT

Original text of this message