How to get non numeric column values from a table?
I need to identify all the non numeric values in a table column. The requirement is as follows.
1. Curently the amount is stored in a VARCHAR2 column ( AMOUNT) of table A.
2. All the data in this table needs to be migrated to new tables. In new tables these columns are having data type of NUMBER.Since the source column is having data type of VARCHAR2 some of values in AMOUNT have non numeric characters. This is causing lot of trouble in migrating the data to a NUMBER field.
Is there any way I can run a SQL to scan the table and identify the records that are having non numeric value in AMOUNT column.