I 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.
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?
Sometimes we like these implicit conversions, other times they can cause problems (as in the conversion blocking the SQL Optimizer from selecting a better plan). But this is forum is only for SQL Developer tool questions.
If you wish to pursue this question, mark this thread as answered and repost in the SQL and PL/SQL forum: SQL and PL/SQL