how to convert varchar to INTEGER in oracle in select query code example Example: oracle sql varchar to number SELECT to_number('1') FROM DUAL;