declare -- Local variables here i binary_integer; Arrleng binary_integer; Type Strings is varray(10) of varchar(100); v_list Strings :=Strings('one','two','three'); begin i:=1;for i in 1..3 loop --insert into table... dbms_output.put_line(v_list(i)); end loop; end;
declare -- Local variables here i binary_integer; Arrleng binary_integer; Type Strings is varray(10) of varchar(100); v_list Strings :=Strings('one','two','three'); begin i:=1;for i in 1..v_list.count loop --insert into table... dbms_output.put_line(v_list(i)); end loop; end;
这些都时要增加数据的,一个字段,请问这样改怎写存储过程,要是在存储过程中,
截取字符串,请问该怎么写,我很急!,谢谢,请告我!
-- Local variables here
i binary_integer;
Arrleng binary_integer;
Type Strings is varray(10) of varchar(100);
v_list Strings :=Strings('one','two','three');
begin
i:=1;for i in 1..3 loop
--insert into table...
dbms_output.put_line(v_list(i));
end loop;
end;
-- Local variables here
i binary_integer;
Arrleng binary_integer;
Type Strings is varray(10) of varchar(100);
v_list Strings :=Strings('one','two','three');
begin
i:=1;for i in 1..v_list.count loop
--insert into table...
dbms_output.put_line(v_list(i));
end loop;
end;