oracle 将科学计数法数据转换为非科学计数法数据

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

oracle 自定义函数:

CREATE OR REPLACE FUNCTION ConvertNumeric(rawData VARCHAR2)
--用于返回转换科学计算法dhx
RETURN VARCHAR2
IS
finalData VARCHAR2();
EIndex INT;
BEGIN
EIndex := ;
EIndex := instr(upper(rawData),'E');
if EIndex> then
if (substr(rawData,EIndex+,)='+' and length(substr(rawData,,EIndex-))> and length(substr(rawData,EIndex+))>) then
finalData:=to_char(to_number(substr(rawData,,EIndex-))*power(,to_number(substr(rawData,EIndex+))));
elsif (substr(rawData,EIndex+,)='-' and length(substr(rawData,,EIndex-))> and length(substr(rawData,EIndex+))> )then
finalData:=to_char(to_number(substr(rawData,,EIndex-))/power(,to_number(substr(rawData,EIndex+))),'fm99999999999999999999990.9999999999999999');
else
finalData:=rawData;
end if;
else
finalData:=rawData;
end if;
RETURN finalData;
EXCEPTION
WHEN OTHERS THEN
finalData:=rawData;
RETURN finalData;
END ConvertNumeric;