create or replace function SensorCode
(
SensorName in varchar2(50)
)
return varchar(50)
is
Result varchar(50)
begin
if (SensorName='一氧化碳') then
Result:='1'
return(Result)
elsif (SensorName='风速') then
Result:='2';
return(Result)
end if
end SensorCode
(
SensorName in varchar2(50)
)
return varchar(50)
is
Result varchar(50)
begin
if (SensorName='一氧化碳') then
Result:='1'
return(Result)
elsif (SensorName='风速') then
Result:='2';
return(Result)
end if
end SensorCode
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货