create procedure spIdGen @id bigint output as
begin
update ZB_ID_GEN set ID = ID + 1, @id = ID + 1;
end GO
这是原来SQL 的存储过程如何转换成oracle的存储过程呢
begin
update ZB_ID_GEN set ID = ID + 1, @id = ID + 1;
end GO
这是原来SQL 的存储过程如何转换成oracle的存储过程呢
out_Id IN NUMBER OUT) IS
Begin
update ZB_ID_GEN set ID = ID + 1,out_Id = ID + 1;
end;
(
id out number
)
as
begin
update ZB_ID_GEN set ID = ID + 1;
id := ID + 1;
end;
(
id1 out number
)
is
begin
update ZB_ID_GEN set ID = ID + 1;
id1 := ID + 1;
end spIdGen;