O P
O P

Reputation: 2365

Minus operator returns error ora-01722

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

Answers (0)

Related Questions