使用Oracle中的Select Satement中的Case返回多个列(returning multiple columns using Case in Select Satement in Oracle)

 我有一个场景，我需要根据主选择语句中的条件从不同的子查询中检索值。 我试图使用Case，但问题是Case不支持多列。 有没有解决这个问题的方法，或者是否有其他方法来达到这个目的？ 
 
 我在一个简化的查询中的场景 
 
select col1,col2,
case when col3='E01089001' then 
        (select 1,3 from dual)
    else
        (select 2,4 from dual)
end
from Table1
where col1='A0529';

I have a sceanrio where i need to retreive values from different sub queries based on a condition in a main select statement. i was trying to use Case, but the problem is that Case does not support multiple columns. Is there any work around to this, or is there any other way to acheive this.
 
My scenario in a simplified query
 
select col1,col2,
case when col3='E01089001' then 
        (select 1,3 from dual)
    else
        (select 2,4 from dual)
end
from Table1
where col1='A0529';

原文：https://stackoverflow.com/questions/700658