RE: Check for all numeric in a column

[Koivu, Lisa]

Title: Message

Hi Ron -

 

in pl/sql, try and convert it with to_number and catch the error if it won't convert.

 

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063

 

 

-----Original Message-----
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Check for all numeric in a column

What is the easiest / best way to check for a valid numeric value in a column?

 

R. Smith

 

If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.