Re: select in statement
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