This discussion is archived
12 Replies Latest reply: Nov 21, 2012 10:56 AM by rp0428 RSS

Two same values are trated different from Oracle perspsective?

Xavi Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points