This discussion is archived
10 Replies Latest reply: Aug 2, 2013 3:44 AM by 1013454 RSS

Character with ascii value '0' not working in NVL...

1013454 Newbie
Currently Being Moderated

Hi ,

I have an issue, working with  'Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi' as our Source and Target . For a record in target nvl(COLUMN,'AA') is returning 'AA' but the same corresponding record in source : nvl(COLUMN,'AA') is returning nothing ( A data field where nothing is there ) , Why is this happening ? Any views....

Legend

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