合理的SELECT ... INTO Oracle解决方案,适用于多个OR无行的情况

DECLARE
  v_emp_name employees.last_name%TYPE;
BEGIN
  SELECT last_name INTO v_emp_name
  FROM employees
  WHERE employee_id = 100;
  DBMS_OUTPUT.PUT_LINE('Employee name: ' || v_emp_name);
END;

DECLARE
  v_emp_name employees.last_name%TYPE;
  v_employee_id employees.employee_id%TYPE := 100;
BEGIN
  FOR i IN 1..10 LOOP
    BEGIN
      SELECT last_name INTO v_emp_name
      FROM employees
      WHERE employee_id = v_employee_id;
      EXIT;
    EXCEPTION
      WHEN NO_DATA_FOUND THEN
        v_employee_id := v_employee_id + 1;
    END;
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('Employee name: ' || v_emp_name);
END;