Home >Database >Mysql Tutorial >在Oracle中判断某个字段的值是否为数字
在Oracle中判断某个字段的值是否为数字
- WBOYOriginal
- 2016-06-07 17:17:041970browse
一表travel_line，里面有pub_price, trade_price两字段，类型为varchar，需要把里面为纯数字的内容提取出来，写个函数来处理：
一表travel_line，里面有pub_price, trade_price两字段，，类型为varchar，需要把里面为纯数字的内容提取出来，写个函数来处理：
使用
select t.pub_price, t.trade_price, t.* from travel_line t where Isnumber(t.pub_price) = 1 and Isnumber(t.trade_price) = 1
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Linux数据库创建与数据导入Next article：Oracle trim函数用法详解