There can be a scenario where the datatype of the column is VARCHAR or CHAR but values that are suppose to be in there are numeric values in that column. In the case when that happens and you would want to detect the row with that issue. SQL> desc test; Name Null? Type ----------------------------------------- -------- … Continue reading How to find row that has non-numeric value in a character column? →