|
SYS.YUDONG>select sum(substr(lpad(5,4),1,2)*60+substr(lpad(55,4),3,2)) from dual;
select sum(substr(lpad(5,4),1,2)*60+substr(lpad(55,4),3,2)) from dual
*
ERROR at line 1:
ORA-01722: invalid number
SYS.YUDONG>select sum(substr(lpad(5,4),1,2)*60+substr(lpad(55,4),3,2)) from dual where 1=2;
SUM(SUBSTR(LPAD(5,4),1,2)*60+SUBSTR(LPAD(55,4),3,2))
----------------------------------------------------
1 row selected.
SYS.YUDONG>select sum(substr(lpad(5555,4),1,2)*60+substr(lpad(5555,4),3,2)) from dual;
SUM(SUBSTR(LPAD(5555,4),1,2)*60+SUBSTR(LPAD(5555,4),3,2))
---------------------------------------------------------
3355
1 row selected.
如果执行了LPAD ,ORACLE给做了隐式数据类型转换,数字类型为何还要用LPAD去处理格式?如果非要处理TO_NUMBER处理一下。 |
|