PL/SQL Control Statements - Oracle Help Center

IF THEN ELSIF Statement The IF THEN ELSIF statement has this structure: IF condition_1 THEN statements_1 ELSIF condition_2 THEN statements_2 [ ELSIF condition_3 THEN statements_3]... [ ELSE else_statements] END IF; The IF THEN ELSIF statement runs the fir

docs.oracle.com