Oracle Database - PLSQL - IF Statement

> Database > Oracle Database

1 - Syntax

IF (is_quarter=1) THEN
     DBMS_OUTPUT.PUT_LINE('This is a quarter');
ELSIF (is_month=1) THEN
     DBMS_OUTPUT.PUT_LINE('This is a month');
ELSE
      raise_application_error(-20001, 'The Periode is not a month or a quarter.');
END IF;
db/oracle/if.txt · Last modified: 2017/09/06 19:28 by gerardnico