oracle varchar 转数字

2022-01-17 00:00:00 numbers oracle varchar

如何将 oracle varchar 值转换为数字

How do i convert a oracle varchar value to number

例如

table - exception
exception_value 555 where exception_value is a varchar type

我想测试 exception_value 列的值

I would like to test the value of exception_value column 

select * from exception where exception_value = 105 instead of
select * from exception where exception_value = '105'

推荐答案

你必须使用 TO_NUMBER 函数:

select * from exception where exception_value = to_number('105')

相关文章