Join between integers and characters
996984Mar 26 2013 — edited Mar 26 2013I have 2 tables, one header and one line, both are joined based on a field X. In header table, it was stored as integer and line table it is stored as varchar.
Header
X
12345
Line
X
'012345'
When I join, I was expecting that the data should not match as one is varchar n the other is integer. Y does oracle implicitly convert the varchar to number and still pass the join?
Thanks!