select
case when (a.name=b.name) then (select * from x)
when (a.name>b.name) then (select * from y)
else (select * from z)
end
from a,b
此语句在ORACLE8.15及以下版本中如何运行或更改
case when (a.name=b.name) then (select * from x)
when (a.name>b.name) then (select * from y)
else (select * from z)
end
from a,b
此语句在ORACLE8.15及以下版本中如何运行或更改
不过你这有些复杂,可能需要改动一下
------------------------------------------------------
OTN 中文技术论坛
OCP 认证 Oracle学习资料
欢迎各路新手和高手光临!
http://211.99.196.144:8090/forum1/frontshow/index.jsp
select * from x where exists(select 1 from a,b where a.name=b.name)
union all
select * from y where exists(select 1 from a,b where a.name>b.name)
union all
select * from z where not exists(select 1 from a,b where a.name=b.name or a.name>b.name)