3 Replies Latest reply: Mar 26, 2013 3:57 PM by 996984 RSS

    Join between integers and characters

    996984
      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.

      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!