declare v_comm_percent constant number:=10; begin update emp set comm=sal*v_comm_percent where deptno=10; endcreate procedure name_pro(p_col1 in varchar2,p_col2 in varchar2,p_table in varchar2) as v_comm_percent constant number:=10; str varchar2(50); begin str:='update '||p_table||' set '||p_col1||'='||p_col2||'*v_comm_percent where deptno=10'; execute immediate str; end; /
sorry,以下: create procedure name_pro(p_col1 in varchar2,p_col2 in varchar2,p_table in varchar2) as v_comm_percent constant number:=10; str varchar2(50); begin str:='update '||p_table||' set '||p_col1||'='||p_col2||'*v_comm_percent where deptno=10'; execute immediate str; end; /
v_comm_percent constant number:=10;
begin
update emp
set comm=sal*v_comm_percent
where deptno=10;
endcreate procedure name_pro(p_col1 in varchar2,p_col2 in varchar2,p_table in varchar2)
as
v_comm_percent constant number:=10;
str varchar2(50);
begin
str:='update '||p_table||' set '||p_col1||'='||p_col2||'*v_comm_percent where deptno=10';
execute immediate str;
end;
/
create procedure name_pro(p_col1 in varchar2,p_col2 in varchar2,p_table in varchar2)
as
v_comm_percent constant number:=10;
str varchar2(50);
begin
str:='update '||p_table||' set '||p_col1||'='||p_col2||'*v_comm_percent where deptno=10';
execute immediate str;
end;
/
但beckhambobo(beckham)兄台写的过程没看明白:)