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 -.

Thanks

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


Current Time: Fri Mar 29 06:55:03 CDT 2024