인덱스 테이블

선언

TYPE 배열이름
IS TABLE OF 테이블명%타입{%TYPE(단일데이터 | %ROWTYPE(테이블전체)} INDEX BY 인덱스형;

활용(예시)

j BINARY_INTEGER := 0;

TYPE tmpTableType
IS TABLE OF T_TMP%ROWTYPE
INDEX BY BINARY_INTEGER;
    
tmpRec    tmpTableType;    


FOR     tmpList
IN      (   SELECT  *
            FROM    T_TMP )                 
LOOP    j := j+1;
        tmpRec(j).TMP_KEY    := tmpList.TMP_KEY;
        tmpRec(j).TMP_LP_KEY := tmpList.TMP_LP_KEY;
END LOOP;