Avoiding "ORA-01722 - Invalid Number" Error When Inserting Data From One Table to Another

If you do an insert into...select * from... statement to insert data from one table to another, it's easy to get the 'ORA-01722 - Invalid Number' error.  In this article, I'll explain why, as well as how to get around it.