我写了一个一维数组,成功了.但写二维数组总是报错.DECLARE
TYPE t1 IS VARRAY (3) OF VARCHAR2 (8);
TYPE t2 IS VARRAY (3) OF t1;
v t2 := t2 ( );
BEGIN
FOR i IN 1 .. 2
LOOP
FOR j IN 1 .. 2
LOOP
v.extend;
v (i) (j) := TO_CHAR (i+j);
DBMS_OUTPUT.put_line (v (i) (j));
END LOOP;
END LOOP;
END;给个table ,varray ,record 的例子也行. 把上面的调通也行.
TYPE t1 IS VARRAY (3) OF VARCHAR2 (8);
TYPE t2 IS VARRAY (3) OF t1;
v t2 := t2 ( );
BEGIN
FOR i IN 1 .. 2
LOOP
FOR j IN 1 .. 2
LOOP
v.extend;
v (i) (j) := TO_CHAR (i+j);
DBMS_OUTPUT.put_line (v (i) (j));
END LOOP;
END LOOP;
END;给个table ,varray ,record 的例子也行. 把上面的调通也行.
---------------------- 单维数组 ------------------------DECLARE
TYPE emp_ssn_array IS TABLE OF NUMBER
INDEX BY BINARY_INTEGER;best_employees emp_ssn_array;
worst_employees emp_ssn_array;BEGIN
best_employees(1) := '123456';
best_employees(2) := '888888';worst_employees(1) := '222222';
worst_employees(2) := '666666';FOR i IN 1..best_employees.count LOOP
DBMS_OUTPUT.PUT_LINE('i='|| i || ', best_employees= ' ||best_employees(i)
|| ', worst_employees= ' ||worst_employees(i));
END LOOP;END;---------------------- 多维数组 ------------------------
DECLARETYPE emp_type IS RECORD
( emp_id employee_table.emp_id%TYPE,
emp_name employee_table.emp_name%TYPE,
emp_gender employee_table.emp_gender%TYPE );TYPE emp_type_array IS TABLE OF
emp_type INDEX BY BINARY_INTEGER;emp_rec_array emp_type_array;
emp_rec emp_type;BEGIN
emp_rec.emp_id := 300000000;
emp_rec.emp_name := 'Barbara';
emp_rec.emp_gender := 'Female';emp_rec_array(1) := emp_rec;emp_rec.emp_id := 300000008;
emp_rec.emp_name := 'Rick';
emp_rec.emp_gender := 'Male';emp_rec_array(2) := emp_rec;FOR i IN 1..emp_rec_array.count LOOP
DBMS_OUTPUT.PUT_LINE('i='||i
||', emp_id ='||emp_rec_array(i).emp_id
||', emp_name ='||emp_rec_array(i).emp_name
||', emp_gender = '||emp_rec_array(i).emp_gender);
END LOOP; END;
-------------- Result --------------
i=1, emp_id =300000000, emp_name =Barbara, emp_gender = Female
i=2, emp_id =300000008, emp_name =Rick, emp_gender = Male
employee_table.emp_name
employee_table.emp_gender这是何物? 报错了.
TYPE emp_type IS RECORD
( emp_id number,
emp_name varchar2,
emp_gender varchar2);