Skip navigation
Contact Us
16759 Views 10 Replies Latest reply: Jun 29, 2014 10:29 PM by Ramesh K 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)