-- Associative Array Indexed by String
DECLARE
-- VARRAY type
TYPE SPORTS IS VARRAY(10) OF VARCHAR(20);
-- nested table type
TYPE BRANDS IS TABLE OF VARCHAR(20);
S_CLS2 SPORTS;
B_CLS2 BRANDS;
BEGIN
S_CLS2 := SPORTS('basketball', 'ping-pong', 'badmiton', 'xxx');
S_CLS2(4) := 'swimming';
FOR I IN 1 .. 4 LOOP
DBMS_OUTPUT.PUT_LINE(I || '.' || S_CLS2(I));
END LOOP;
B_CLS2 := BRANDS('Nike', 'Anta', '361', 'xxx');
B_CLS2(4) := 'Jordan';
FOR I IN 1 .. 4 LOOP
DBMS_OUTPUT.PUT_LINE(I || '.' || B_CLS2(I));
END LOOP;END;
/
-- Associative Array Indexed by StringDECLARE TYPE ASS_ARR1 IS TABLE OF NUMBER INDEX BY VARCHAR2(64); ASS_ARR ASS_ARR1; I VARCHAR2(63);BEGIN ASS_ARR('a') := 1; ASS_ARR('b') := 2; ASS_AR