Re: select in statement

Why don't you use INSTR function?

amitabh12_at_my-dejanews.com wrote:
>
> 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

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru