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 -- //www.freelists.org/webpage/oracle-l