oracle varchar to number December 12, 2023 by Tarik You have to use the TO_NUMBER function: select * from exception where exception_value = to_number('105')