Live ORACLE

DECLARE

  on_hand   INTEGER := 0;

   on_order  INTEGER := 100;

BEGIN

  -- Does not cause divide-by-zero error; evaluation stops after first expression

  IF (on_hand = 0)

      OR ((on_order / on_hand) < 5) THEN

    dbms_output.Put_line('On hand quantity is zero.');

  END IF;

END;

/

Short-Circuit Evaluation