How to query a string that is completely numbers

zhaozj2021-02-12  142

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 ----- -----1

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

New Post(0)