示例：声明关联数组

DECLARE
    -- 声明关联数组，不带游标
    TYPE TYPE_WARE IS TABLE OF ware%ROWTYPE INDEX BY PLS_INTEGER ;  
    TYPE TYPE_WARE_NAME IS TABLE OF ware.w_name%TYPE INDEX BY ware.w_id%TYPE; 
    ware_names  TYPE_WARE_NAME;
BEGIN
END;
/
delimiter ;