Excuse me in ORACLE, WHERE to_number BETWEEN parameters under the condition of how to use?

CodePudding user response:

- this mean?
Where col_name between to_number (' 123 ') and to_number (' 456 ')

CodePudding user response:

Is that the invalid number error,

CodePudding user response:

An error that the back of the value is a problem, cannot be converted to digital,

Such as: ABD, 123 a, A123, 123, 123, the content,

CodePudding user response:

Don't to_number, remove the quotes directly, is ok,

CodePudding user response:

Description field cannot be converted to digital, it is recommended that the first inspection data, oracle is not directly determine whether digital function, can examine judging function under the baidu