A quiz of a slightly different kind this time. The following SQL raises an ORA-01722 (invalid number) exception:
select * from this_simple_join tsj, does_not_work dnw where tsj.column_1 = dnw.column_1 and tsj.column_2 = dnw.column_2; ORA-01722: invalid number
We can fix this so no error is returned without changing the SQL statement itself. How is this possible?
Put your answers in the comments! I’ll post my full solution on Monday.