17,140
社区成员




declare
li_num number(1);
ls_sql varchar2(2000);
begin
if li_num =1 then
ls_sql=' update emp set job =''1''' ;
else if li_num=2 then
ls_sql=' update emp set ename =''1''' ;
else if li_num = 3 then
ls_sql=' update emp set sal=1 ' ;
end if ;
end if ;
end if ;
execute immediate ls_sql ;
end ;
declare
li_num number(1);
begin
if li_num =1 then
update emp set job ='';
else if li_num=2 then
update emp set mgr='';
else if li_num = 3 then
update emp set sal =100;
end if ;
end if ;
end if ;
end ;