oracle与sqlserver存储过程哪个更容易理解哪个语句更复杂
答案:2 悬赏:0 手机版
解决时间 2021-02-22 21:11
- 提问者网友:喧嚣尘世
- 2021-02-22 09:09
oracle与sqlserver存储过程哪个更容易理解哪个语句更复杂
最佳答案
- 五星知识达人网友:青灯有味
- 2021-02-22 09:49
oracle更易于理解,毕竟别人用PL/SQL写存储过程,更方便
个人观点
个人观点
全部回答
- 1楼网友:玩世
- 2021-02-22 11:25
变量好混乱,一会有v_一会又没了,你确认你贴的代码能执行吗?
create or replace procedure skygetbizkey(v_addcount number,
v_keyname varchar2,
v_retval out number) as
v_count number;
begin
select count(1) into v_count from skybizkeys where bizform = v_keyname;
if v_count > 0 then
select nvl(indexvalue, 0) + 1
into v_retval
from skybizkeys
where bizform = v_keyname
and rownum = 1;
select count(1)
into v_count
from skybizkeys
where bizform = '$instance'
and indexvalue > v_retval;
if upper(v_keyname) = '$tempinstance' and v_count > 0 then
select nvl(indexvalue, 0) + 1
into v_retval
from skybizkeys
where bizform = '$instance'
and rownum = 1;
end if;
update skybizkeys
set indexvalue = v_retval + v_addcount - 1
where bizform = v_keyname;
else
insert into skybizkeys
(bizform, indexvalue)
values
(v_keyname, v_addcount + 1);
v_retval := 1;
end if;
commit;
end;
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯