While inserting data from one table to another table I've got below error. I want to know which column has datatype issue.
Why can't oracle also show the columns in these case as it just shows the error and it is difficult to find the column name.
SQL Error: ORA-00932 ,inconsistent datatypes: expected NUMBER got CHAR.