declare
v_id varchar2(255);
v_od varchar2(11);
v_it varchar2(4);
v_stat varchar2(20);
cursor c_emp is select * from bon where d='144' ;

begin
for t in c_emp loop
dbms_output.put_line('v_id is '||t.id);
end loop;
end;

begin
open c_emp;
loop
fetch c_emp into v_id,v_od,v_it,v_stat;
exit when c_emp%notfound ;
dbms_output.put_line('v_id,v_od,v_it,v_stat is '||v_id||' '||v_od||' '||v_it||' '||v_stat);
if v_id='244' then
update bon set it_value='03' where id=v_id;
dbms_output.put_line('has changed'||v_id);
end if;

end loop ;

end;

ITPub博客

pl/sql之初体验

最新文章