DECLARE
TYPE t_test1 IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER ;
v_table t_test1;
BEGIN
v_table(1):='上海';
v_table(2):='上海1';
v_table(3):='上海2';
FOR i IN 1..v_table.COUNT
LOOP
DBMS_OUTPUT.PUT_LINE(v_table(i));
END LOOP;
END;
declare
type t_test1 is table of number index by varchar2(10);
area_tab t_test1;
v_index varchar2(10);
begin
v_index := area_tab.first;
dbms_output.put_line('the table index is :'||v_index);
loop
v_index := area_tab.next(v_index);
exit when v_index is null;
dbms_output.put_line('the table index is :'||v_index);
end loop;
end;