oracle 定义临时变量，并使用分支判断
时间：2021-07-01 10:21:17
帮助过：37人阅读
tempCount
int;
tempID VARCHAR2(
8);
begin
select count(
*)
into tempCount
from CUSTOMER_PROFILE
where id
=:CUSTOMER_ID;
if tempCount
>0 then
update CUSTOMER_PROFILE
set name
=:CUSTOMER_NAME,address
=:CUSTOMER_ADDRESS,phone
=:CUSTOMER_PHONE,description
=:CUSTOMER_DESCRIPTION,update_user_id
=:
USER_ID,update_date
=sysdate;
else
begin
select ID
into tempID
from ID_POOL
where status
=0 and rownum
=1;
insert into CUSTOMER_PROFILE(id,name,address,phone,description,create_user_id)
values(tempID,:CUSTOMER_NAME,:CUSTOMER_ADDRESS,:CUSTOMER_PHONE,:CUSTOMER_DESCRIPTION,:
USER_ID);
update ID_POOL
set STATUS
=1 where id
=tempID;
end;
end if;
end;
oracle 定义临时变量，并使用分支判断
标签：name where res desc div count varchar2 hone declare
