Oracle数组使用以及PLSQL操作记录

发布时间：2020-12-12 15:57:19 所属栏目：百科来源：网络整理

导读：----------------------------固定长度数组 declare type intarray is varray(30) of varchar2(100); var_arr intarray := intarray('a','b','c','d'); begin for i in 1..var_arr.count loop dbms_output.put_line(var_arr(i)); end loop; end; -----------

----------------------------固定长度数组
declare
type intarray is varray(30) of varchar2(100);
var_arr intarray := intarray('a','b','c','d');
begin
for i in 1..var_arr.count
loop
dbms_output.put_line(var_arr(i));
end loop;
end;
---------------------------未知长度数组
type vararray is table of varchar2(50) index by binary_integer;
var_arr vararray;
for i in 1..15 loop
var_arr(i) := i+10;
dbms_output.put_line('Count: '|| var_arr.count);
dbms_output.put_line(var_arr(11));

------------------------自定义1
var_phone varchar2(100);
idex int;
nextIdex int;
iphone varchar2(100);
var_phone := '10000,10001,10002,10003,10004';
dbms_output.put_line(var_phone);
idex := 0;
nextIdex := 1;
while nextIdex > 0 loop
nextIdex := instr(var_phone,',idex+1);
dbms_output.put_line(idex || ' --- ' || nextIdex);
if nextIdex > 0 then
iphone := substr(var_phone,idex+1,nextIdex-idex-1);
else
end if;
idex := nextIdex;
dbms_output.put_line(iphone);
end loop;
------------------- 自定义2 使用数组
var_phone varchar2(100) := '1000';--'10000,sans-serif; line-height:25.2px">type charArray is table of varchar2(100) index by binary_integer;
phone_arr charArray;
arrCount int := 1;
phone_arr(arrCount) := substr(var_phone,sans-serif; line-height:25.2px"> arrCount := arrCount + 1;
--dbms_output.put_line();
for i in 1..phone_arr.count loop
dbms_output.put_line(phone_arr(i));
end;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!