oracle中判断是否为数字,不是数字赋0值.
保证结果是数字值:

SELECT to_number(NVL2 (TRANSLATE (a.store_user, '\1234567890 ', '\ '), '0', a.store_user))  FROM user_info a;
Comments(0) | Trackbacks(0) | Reads(1179)
Add a comment
Nickname [Register]
Password Optional
Site URI
Email
Enable HTML Enable UBB Enable Emots Hidden Remember