select count(*)
into l_cnt
from dual
where exists (select null from xxx where yyy = zzz)