Re: select in statement

From: Luc Gyselinck <Luc.Gyselinck_at_village.uunet.be>
Date: Fri, 22 Jan 1999 00:05:00 +0100
Message-ID: <788c58$enf$1_at_nickel.uunet.be>


This does not work. The bind variable is substituted by the one and only value ''HIGH SCHOOL','UNIVERSITY''
So your looking for the whole string, not the 'parts' of the string you pass...

amitabh12_at_my-dejanews.com wrote in message <787qau$uan$1_at_nnrp1.dejanews.com>...
>Hello
>
>I am using Oracle 8 database with oracle developer 2000 v5...
>
>I am trying to write a pl/sql statement but the following statements
returns
>no records..
>
>SELECT (*) FROM table_name
>WHERE column_name in (:criteria);
>
>criteria is a non base table and it has values
>'HIGH SCHOOL','UNIVERSITY'..
>
>Thanks in advance
>Munish
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 22 1999 - 00:05:00 CET

Original text of this message