create or replace procedure depart_update( departmentid_in in departments.id%type) as v_sign number(2); begin select 1 into v_sign from departments where id=departmentid_in;
if v_sign=1 then update departments set update_statement--这里添加更新项 where id=departmentid_in; commit; else null end if;
exception when others then rollback; end depart_update;
试试这个是你想要的么 create or replace procedure depart_update( value1 in nvarchar2, value2 in nvarchar2, departmentid in nvarchar2 ) is begin update DEPARTMENTS t set t.field1 = value1, t.field2 = value2 where t.departmentid = departmentid end depart_update
看一下这本书《精通Oracle 10g PL/SQL编程》,自己动手写一下吧
下载电子版
create or replace procedure depart_update(
departmentid_in in departments.id%type)
as
v_sign number(2);
begin
select 1 into v_sign
from departments
where id=departmentid_in;
if v_sign=1 then
update departments
set update_statement--这里添加更新项
where id=departmentid_in;
commit;
else null
end if;
exception
when others then
rollback;
end depart_update;
试试这个是你想要的么
create or replace procedure depart_update(
value1 in nvarchar2,
value2 in nvarchar2,
departmentid in nvarchar2
)
is
begin
update DEPARTMENTS t
set t.field1 = value1,
t.field2 = value2
where t.departmentid = departmentid
end depart_update