FOR LOOP

DECLARE
  a NUMBER;
BEGIN
    FOR i IN 1..30 LOOP
      DBMS_OUTPUT.PUT_LINE(‘NUMERALS : ‘||TO_CHAR(I));
    END LOOP;
END;

IF THEN ELSE IF

DECLARE
v_start NUMBER;
BEGIN
v_start := 85;
IF v_start > 100 THEN
v_start := 0.2 * v_start;
DBMS_OUTPUT.PUT_LINE(‘Result = ‘||v_start);
ELSIF v_start >= 50 THEN
v_start := 0.5 * v_start;
DBMS_OUTPUT.PUT_LINE(‘Result = ‘||v_start);
ELSE
v_start := 0.1 * v_start;
DBMS_OUTPUT.PUT_LINE(‘Result = ‘||v_start);
END IF;
END;

IF THEN ELSE Condition

DECLARE
v_hire_date DATE := ’12-Dec-1990′;
v_five_years BOOLEAN;
BEGIN
IF MONTHS_BETWEEN(SYSDATE,v_hire_date)/12 > 5 THEN
DBMS_OUTPUT.PUT_LINE(‘Hire Date ‘||v_hire_date||’ is Greater than 5 Years’);
ELSE
DBMS_OUTPUT.PUT_LINE(‘Hire Date ‘||v_hire_date||’ Less than 5 Years’);
END IF;
END;

Simple If Condition

DECLARE
v_name VARCHAR2(50);
BEGIN
v_name := ‘Chain-Sys’;
IF v_name = ‘Chain-Sys’ THEN
DBMS_OUTPUT.PUT_LINE(‘Name is ‘||v_name);
END IF;
END;

PL/ SQL Statement

DECLARE
A NUMBER;
B NUMBER;
RES NUMBER;
BEGIN
A := 50;
B := 75;
RES := A + B;
DBMS_OUTPUT.PUT_LINE(‘A + B = ‘||RES);
END;