三叶草 发表于 2022-1-28 11:10:06

Oracle判断指定列是否全部为数字的sql语句


select nvl2(translate(name,'\1234567890 ', '\'),'is characters ','is number ') from customer_info where nvl2(translate(name,'\1234567890 ', '\'),'is characters ','is number ')='is number '

https://www.uoften.com/dbs/oracle/20180415/72977.html
页: [1]
查看完整版本: Oracle判断指定列是否全部为数字的sql语句