Oracle里使用CASE的办法:
SELECT CASE WHEN UPPER(A.LANGUAGE_CODE) = 'ZH-CN' THEN B.CHINESE ELSE B.ENGLISH END AS LANGUAGE_NAME
FROM TBL A,TBL1 B WHERE A.ID=B.ID