Seperate the rows

Hi,
i have data which looks like below

Table a

code  text                                  lang

101    North America                   E  
102   l'amérique du nord              F


I want output as  

code  text _english      text_french                       lang

101    North America                                               E  
102                             l'amérique du nord              F


how can i do that.

Thanks
sam2929Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
awking00Connect With a Mentor Commented:
select code, decode(lang,'E',text) as text_english, decode(lang,'F',text) as text_french, lang
from tablea;
0
 
Farzad AkbarnejadDeveloperCommented:
Hello,
Suppose you have your data in tblTest. Write the following query to get proper result:

select t.code, case when lang='E' then text end text_english,
               case when lang='F' then text end text_french,
       t.lang
 from tblTest t

Open in new window

-FA
0
All Courses

From novice to tech pro — start learning today.