Declare Array in PL/SQL

 

-- declare NUMBER of Array TYPE and Parameter

TYPE t_number_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
number_array          t_number_array;

-- declare VARCHAR2 的 Array TYPE and Parameter

TYPE t_varchar2_array IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
string_array          t_varchar2_array;

-- 塞值進 Number Array 
number_array(1) := 123;
number_array(2) := 456;
number_array(3) := 789;