In article <39d621f0.54898851_at_news.mindspring.com>, James A. Williams
<willjamu_at_mindspring.com> writes
>I have a user with an application with a column of a table defined as
>VARCHAR2 instead of NUMBER for whatever reason. The table has no
>constraints about the column in question at the moment. When the data
>comes from DB2 on OS/390 (where there can be a dash in the number
>occasionally it is inserted into the Oracle table. Users use the TONUM
>function to convert the value to a number for processing. We if dashes
>are in the column this does not work. What would be a query I could
>use to check for all varchar2 's that can't be converted to a number?
>
just use to_number and catch the exceptions...
Steve
Received on Sat Sep 30 2000 - 18:36:19 CDT
