Re: Q: please make it work :)

where rownum = 1

On 05/06/2008, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> select 1 from dual; That is the point of dual. Of course a functional
> description of why this odd construction appears would help, since I'm
> guessing that actually you don't want 1 row but one row when some
> logical decision is true. .
>
>
> On 05/06/2008, Amihay Gonen <AmihayG_at_ectel.com> wrote:
> > 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 <mail%3Aamihayg_at_ectel.com>
> > msn :agonenil_at_hotmail.com
> >
> >
> >
> >
> >
> >
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Howard A. Latham

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