Oracle Database - PLSQL - IF Statement

Card Puncher Data Processing

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;







Share this page:
Follow us:
Task Runner