Skip navigation
Contact Us
4832 Views 5 Replies Latest reply: Dec 10, 2012 10:37 PM by chadrababu a RSS
lavan kumar Apprentice 169 posts since
Apr 13, 2011
Currently Being Moderated

Dec 6, 2012 12:24 AM

how to use decode function in this scenario..?

Hi Folks,

 

My source table is  like below

 

 

COL_1     COL_2     COL_3     COL_4    

Prakash     1520       SE          USD

Kiran          2500      SSE        EUZ

ramesh       4500      SE          USD

Bhagat        2000      SE          EUZ              

Madhu         2550     SSE         GBP

 

 

And My requirement is i need to replace the "COL_4"  

where  COL_3 = SE AND COL_4 = EUZ THEN COL_4 SHOULD BE REPLACE AS EUR

 

So here i neeed to be satisfy two conditions then only the output has to be replaced.

 

 

Thanks,

Lavan

More Like This

  • Retrieving data ...

Bookmarked By (0)