Using string variables in Select statements
Date: Thu, 01 May 2008 11:07:03 -0400
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. Received on Thu May 01 2008 - 10:07:03 CDT