RE: Simple Select Return Record

Hi  

>select count(*)=20

>from dual

>where exists (select null from employee_tbl where employeeid=3D5);
 

If excellent performance is a must, don't do that.

To fetch a single row from a query and set a flag is faster.    

HTH Chris

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