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;
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; --结果 上海 上海1 上海2
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;
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;
--结果
上海
上海1
上海2
v_table(1):='上海';
v_table(2):='上海1';
v_table(3):='上海2';我需要的是1,2,3.下标.