What is the suitable query to check the value in the Language_Notation and then accordingly return the values. (You want the value to be displayed from Desc_eng,if the value=E else display value from Desc column
(a)select Decode (Language_Notation,’É’,Desc,desc_eng) from Language_Used
(b) select Decode (Language_Notation,’É’,Desc_eng,Desc) from Language_Used
(c ) select Decode (’É’,Desc_eng,Desc, Language_Notation,) from Language_Used
(d) select Decode (Language_Notation,’É’,Desc_eng) from Language_Used