Try the following.......


select 1 from emp
where (empno,ename)=(select 7369,'smith' from dual);

Hope this helps

Regards

Deepak
----- Original Message -----
From: "Deepak Kumar Khosla "
<oracledba-ezmlmshield-x43199669.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, April 29, 2005 10:21 AM
Subject: help query


>
> hi
> why this query is not running ?
>
> select 1 from emp
> where (empno,ename) = (7369,'smith')
> Thanks and Regards
>
> Deepak Khosla
> ORACLE
> System Executive
> Rapidigm India Pvt. Ltd.
> SEI CMM Level-5
> Phone (+91) 120 - 2444725/26 Extn -1241
> www.rapidigm.com
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page