17,377
社区成员
发帖
与我相关
我的任务
分享
--给你个例子:
declare
type ename_table_type is table of emp.ename%type ;--index by binary_integer;
type sal_table_type is table of emp.sal%type; --index by binary_integer;
ename_table ename_table_type;
sal_table sal_table_type:=sal_table_type();
sql_stat varchar2(200);
begin
ename_table:=ename_table_type('SCOTT','SMITH','ALLEN');
sql_stat:='update emp set sal=sal*1.1 where ename=:1 returning sal into :2';
forall i in 1..ename_table.count
execute immediate sql_stat using ename_table(i) returning bulk collect into sal_table;
for j in 1..ename_table.count loop
dbms_output.put_line('雇员:'||ename_table(j)||'的薪水:'||sal_table(j));
end loop;
end;
/
PL/SQL block, executed in 0.454 sec.
雇员:SCOTT的薪水:3300
雇员:SMITH的薪水:880
雇员:ALLEN的薪水:1760
Total execution time 0.454 sec.