这么写好像有点麻烦的样子。。有简单的方法吗。
select A.content,B.content from (select * from sy_global_name where language='zh') A,(select * from sy_global_name where language='ko') B
where A.no=B.no
------解决思路----------------------
是一一对应的关系吗？很普通的行转列的需求，11g以后还可以考虑使用pivot实现
select max(decode(language,'zh',content)),max(decode(language,'ko',content))
FROM sy_global_name
group by no