DECLARE
TYPE employee IS TABLE OF VARCHAR (5);
employees employee:= employee ('A', 'B', 'C', 'D','E');
BEGIN
FOR i IN employees.FIRST .. employees.LAST
LOOP
IF employees (i) = 'C'
THEN
DBMS_OUTPUT.PUT_LINE (employees (i));
END IF;
END LOOP;
END;
TYPE employee IS TABLE OF VARCHAR (5);
employees employee:= employee ('A', 'B', 'C', 'D','E');
BEGIN
FOR i IN employees.FIRST .. employees.LAST
LOOP
IF employees (i) = 'C'
THEN
DBMS_OUTPUT.PUT_LINE (employees (i));
END IF;
END LOOP;
END;