oracle函数和存数过程转成mysql
来源：动视网
责编：小采
时间：2020-11-09 16:58:26
oracle函数和存数过程转成mysql
oracle函数和存数过程转成mysql:mysqloracle函数 create or replace function public_f_get_bsc012(v_id in varchar2)return varchar2asv_temp varchar2(200);beginselect bsc012 into v_temp from sc05 where bsc010=v_id; r
导读oracle函数和存数过程转成mysql:mysqloracle函数 create or replace function public_f_get_bsc012(v_id in varchar2)return varchar2asv_temp varchar2(200);beginselect bsc012 into v_temp from sc05 where bsc010=v_id; r
mysqloracle函数
create or replace function public_f_get_bsc012
(
v_id in varchar2
)
return varchar2
as
v_temp varchar2(200);
begin
select bsc012 into v_temp from sc05 where bsc010=v_id;
return v_temp;
exception when others then
return '';
end ;
初学，以上是oracle函数，在mysql上一直没写对，求大侠指教
oracle函数和存数过程转成mysql
oracle函数和存数过程转成mysql:mysqloracle函数 create or replace function public_f_get_bsc012(v_id in varchar2)return varchar2asv_temp varchar2(200);beginselect bsc012 into v_temp from sc05 where bsc010=v_id; r
