Join with a + 0
I'm trying to understand a oracle sql query which was generated from an application and got captured through Toad.
select a.cust, a.date. a.qnty
from orders a
where a.numb + 0 = 1002
a.numb is an integer. I'm trying to understand what this + 0 means. Note there are no braces. The query takes long time to execute with the presence of + 0. If I remove + 0 (i.e, a.numb = 1002), it executes much faster.
Appreciate if anyone could shed some light on what is going on.
Oracle version is 7.3
Click Here to Expand Forum to Full Width