declare
type arr is table of number;
myArray arr;
begin
myArray:=arr(1,2,3,4,5,6,7,8);
for i in myArray.first..myArray.last
loop
dbms_output.put_line(to_char(i));
end loop;
end;
type arr is table of number;
myArray arr;
begin
myArray:=arr(1,2,3,4,5,6,7,8);
for i in myArray.first..myArray.last
loop
dbms_output.put_line(to_char(i));
end loop;
end;
解决方案 »
- 安装oracle报错 JavaThread "AWT-EventQueue-0"
- C#,将DataTable中的数据批量导入到Oracle数据库中
- 如何将数据从USER1复制到?USER2?
- oracle 10g 数据库无法启动
- 为何PL/SQL Developer在远程打开数据库后,突然关闭??
- 大侠们,我被难住了,请帮忙?
- 帮帮我!oracle的安装问题
- select返回多条记录时怎么办?
- 在plsql中,如果要从一个有100万行的表中把数据读出来到变量中,然后把变量写到文件中,应该怎么做,游标太慢了。
- 紧急事情!如何在P4的机器上安装ORACLE 8I呀!请快点告诉我呀!重谢!
- oralce 大数据量
- Oracle Noarchive 模式备份和恢复限制性都比 archivelog 模式大, 那 Noarchivelog 有什么优点呢?
type arr is table of number index by BINARY_INTEGER;
myArray arr;
i number default 1;
begin
loop
myArray(i):=i;
exit when i>10;
i:=i+1;
end loop;
loop
exit when i<1;
dbms_output.put_line(to_char(myArray(i)));
i:=i-1;
end loop;
end;
type arr is varray(5) of number;
myArray arr;
begin
myArray:=arr(1,2,3,4,5);
for i in myArray.first..myArray.last
loop
dbms_output.put_line(to_char(i));
end loop;
end;
type arr is table of number index by varchar2(1);
myArray arr;
begin
myArray('A'):=1;
myArray('B'):=2;
dbms_output.put_line(myArray('A'));
dbms_output.put_line(myArray('B'));
end;
create or replace procedure p
as
type arr is table of number index by PLS_INTEGER;
myArray arr;
begin
for i in 1..10
loop
myArray(i):=i;
end loop;
for i in 1..myArray.count
loop
dbms_output.put_line(to_char(myArray(i)));
end loop;
end;--测试
begin
p;
end;
create or replace type arr as table of number;--创建存储过程
create or replace procedure p(myArray arr)
as
begin
for i in myArray.first..myArray.last
loop
dbms_output.put_line(to_char(i));
end loop;
end;--测试
declare
myArray arr:=arr(1,2,3,4,5);
begin
p(myArray);
end;
已经有人回答出来了再答没有太大的意思拉