How to query a string that is completely numbers

zhaozj2021-02-12  138

SQL> SELECT 1 from Dual WHERE LTRIM ('12385x2', '0123456789') is NULL; unselected line SQL> SELECT 1 from Dual WHERE LTRIM ('123852', '0123456789') is NULL; 1 ----- ----- 1SQL>

转载请注明原文地址:https://www.9cbs.com/read-7575.html

New Post(0)