Re: Q: please make it work :)

Perhaps you need something like:

    SQL> select 1 from dual where NUMTAB(9,8,4) *submultiset of*     NUMTAB(4,8,9,33) ;              1

             1

    1 row selected.

i.e. (9,8,4) is a subset of (4,8,9,33).

-----Original message-----
From: Amihay Gonen
Date: 5/6/08 15:14
>
> I need idea to change this sql to return one row.
>
>
>
> select 1 from dual where NUMTAB(9,8,4) in NUMTAB(4,8,9,33) ;
>
>
>
>
>
>
>
> /Amihay Gonen/
>
> /Dba Team Leader/
>
> /PD Division/
>
> /ECTel Ltd./
>
> /celluar:+972-525092168/
>
> /tel:+972-3-9002168/
>
> /mail:amihayg_at_ectel.com/
>
> /msn :agonenil_at_hotmail.com/
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l