Home » RDBMS Server » Server Administration » Validate string before to_number
Validate string before to_number [message #371139] Tue, 05 September 2000 16:28
Don Keyes
Messages: 3
Registered: September 2000
Junior Member
Is there a way to make sure that a string contains a valid number before trying to using to_number() to convert it to a number? We don't want our SQR program to crash with an invalid string error when it hits the to_number() line. I can't figure out to use instr to test for characters not equal to 0-9,+ or -.


Don Keyes
Previous Topic: .ora file
Next Topic: TRACE
Goto Forum:

Current Time: Fri Sep 29 19:31:39 CDT 2023