Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
"CORE12.1.0.2.0Production"
TNS for 64-bit Windows: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
with function Is_Number
(x in varchar2) return varchar2 is
Plsql_Num_Error exception;
pragma exception_init(Plsql_Num_Error, -06502);
begin
if (To_Number(x) is NOT null) then
return 'Y';
else
return '';
end if;
exception
when Plsql_Num_Error then
return 'N';
end Is_Number;
select Is_Number('www.xifenfei.com') is_num from dual;
12c里执行报错了?咋回事啊?哪里写错了?
dexter@PDBSTK> with function Is_Number
2(x in varchar2) return varchar2 is
3
Plsql_Num_Error exception;
4
pragma exception_init(Plsql_Num_Error, -06502);
5 begin
6 if (To_Number(x) is NOT null) then
7 return 'Y';
8 else
9 return '';
10end if;
11 exception
12 when Plsql_Num_Error then
13 return 'N';
14end Is_Number;
15select Is_Number('www.xifenfei.com') is_num from dual;
16/
IS_NUM
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
N
复制代码ok啊