Reputation: 2365
I have row, which is a character field, but is compared to numeric values in conditions. This causes ORA-01722 invalid number error under some circumstances.
Instead of: row in (1, 2, 3, 4, 5, 7)
It should be: row in (‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘7’)
This query returns ORA-01722:
(select * from table@production)
minus
(select * from table)
How can the query above be modified?
Upvotes: 0
Views: 517