--将字符转换成数字-- CREATE OR REPLACE function CharToNumber(strNumber varchar2) RETURN NUMBER IS BEGIN RETURN (to_number(strNumber)); EXCEPTION WHEN others THEN RETURN (0); END ; / --调用-- SELECT CharToNumber(HHH) FROM bdlly.T10_XZMD;
--将字符转换成数字-- CREATE OR REPLACE function CharToNumber(strNumber varchar2) RETURN NUMBER IS BEGIN RETURN (to_number(strNumber)); EXCEPTION WHEN others THEN RETURN (0); END ; / --调用-- SELECT CharToNumber(HHH) FROM bdlly.T10_XZMD;
转载于:https://www.cnblogs.com/siyunianhua/p/3790967.html