记忆力不好,提供样例套路:
固定长度数组:
declare type t_test is varray(5) of varchar2(9); test t_test := t_test('a', 'b', 'c', 'd', 'e'); begin --遍历 for i in 1 .. test.count loop dbms_output.put_line(test(i)); end loop; end<
记忆力不好,提供样例套路:
固定长度数组:
declare type t_test is varray(5) of varchar2(9); test t_test := t_test('a', 'b', 'c', 'd', 'e'); begin --遍历 for i in 1 .. test.count loop dbms_output.put_line(test(i)); end loop; end<