-
Join with a + 0
Hello everyone,
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
Thanks
CKR
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|