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/

References:

Q: please make it work :)
From: Amihay Gonen

Re: Q: please make it work :)

Other related posts: