asked on

oracle sql exists clause

Is there a more efficient/faster or more elegant way to do this statement with just the exists clause? I use these in triggers all over the place so I'd like to improve it if possible.
SQL Developer SQL Tuning Advisor says "no recomendation to improve it"

set serveroutput on;
declare l_count number;
begin
SELECT COUNT(*)
    INTO l_count
    FROM dual
    WHERE EXISTS
      (SELECT employee_id FROM hr.employees WHERE manager_id = 114);

if l_count > 0 then
 dbms_output.put_line ('found some');
end if;
    
end;

Open in new window

ajexpert

How about this?

set serveroutput on;

DECLARE
   l_count   NUMBER :=0;
BEGIN
   SELECT   COUNT (employee_id)
     INTO   l_count
     FROM   hr.employees
    WHERE   manager_id = 114;

   IF l_count > 0 THEN
      DBMS_OUTPUT.put_line ('found some');
   END IF;
END;

Open in new window