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;
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;