Re: Q: please make it work :)

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
> msn :agonenil_at_hotmail.com
>
>
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l