Re: Q: please make it work :)
- From: William Robertson <william@xxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 06 Jun 2008 07:36:02 +0100
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@xxxxxxxxx/
/msn :agonenil@xxxxxxxxxxx/
Other related posts:
