12 Replies Latest reply: Nov 21, 2012 12:56 PM by rp0428 RSS

    Two same values are trated different from Oracle perspsective?

    Xavi
      Hello, I have two values that apparently are the same.

      select distinct record_mod from T_NSW_STG_LEG_SCHEDULE t where T.SRC_CONT_ID = '142590080818000000000' and t.schd_amt = 293.34;

      the result is

      RECORDMOD_
      3
      3

      Why if the values are identical oracle saysthe are different. The only thing I know is that they are in different partitions.

      Thanks in advance!