sql语句:select @ID= SubString(@RegionID,1,2)+ Right( Max( Convert(int, SubString(RegionId,3,2)))+101,2)+'000000' from region where left(RegionId,2)=left(@RegionID,2)怎么转变成ORACLE语句呀
select @ID= 'SubStr(@RegionID,1,2)'|| 'Right( Max( to_number(int, SubStr(RegionId,3,2)))+101,2)'||'000000' from region where left(RegionId,2)=left(@RegionID,2)
select @ID= 'SubStr(@RegionID,1,2)'|| 'Right( Max( to_number(int, SubStr(RegionId,3,2)))+101,2)'||'000000' from region where left(RegionId,2)=left(@RegionID,2)
'Right( Max( to_number(int, SubStr(RegionId,3,2)))+101,2)'||'000000'
from region
where left(RegionId,2)=left(@RegionID,2)