The following nesting of Oracle functions can be used for validating two different columns between source and target tables.
decode(replace(trim(nvl(a.STREET_NAME,0)),trim(nvl(b.STREET_NAME,0)),'Y'),'Y','Y','N')
Will return 'Y' if the value matches between two columns and 'N' otherwise.
Please put some comments in my blog for any doubts regarding the same.
No comments:
Post a Comment