DB/PLSQL
PLSQL 2차원 배열
냐옴
2013. 12. 12. 16:38
DECLARE
TYPE T_LIST IS TABLE OF VARCHAR2(50);
TYPE T_LIST2 IS TABLE OF T_LIST;
V_LIST T_LIST2;
BEGIN
V_LIST := T_LIST2(
T_LIST('11', '12', '13'),
T_LIST('21', '22', '23'),
T_LIST('31', '32', '33')
);
FOR I IN 1..V_LIST.COUNT
LOOP
FOR J IN 1..V_LIST(I).COUNT
LOOP
DBMS_OUTPUT.PUT(V_LIST(I)(J) || ' ');
END LOOP;
DBMS_OUTPUT.PUT_LINE('');
END LOOP;
END;