select in statement

From: <amitabh12_at_my-dejanews.com>
Date: Thu, 21 Jan 1999 18:06:32 GMT
Message-ID: <787qau$uan$1_at_nnrp1.dejanews.com>



Hello

[Quoted] 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 Thu Jan 21 1999 - 19:06:32 CET

Original text of this message