Re: Q: please make it work :)

> numtab looks like your own custom function.
> Oracle table dual should have one record only and will return you one
record only, unless this is again some custom thing..

thanks!
amar

On Thu, Jun 5, 2008 at 6:31 PM, Joerg Jost <joerg.jost_at_unitrade.com> wrote:

> Am Donnerstag, den 05.06.2008, 17:14 +0300 schrieb Amihay Gonen:
> > select 1 from dual where NUMTAB(9,8,4) in NUMTAB(4,8,9,33) ;
>
> 
> select distinct 1 from dual where NUMTAB(9,8,4) in NUMTAB(4,8,9,33) ;
>
> hth
>
> Jörg Jost
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thanks!
Amar Kumar Padhi
Oracle DBA/Architect
--
http://www.freelists.org/webpage/oracle-l