解决方案 »
- oracle 11g 2 只有命令行版的sqlplus吗?
- 如何用toad for oracle 监视我的程序执行了哪些slq语句和执行到哪条sql了
- oracle语句如何强制走索引
- 如何将.net传入的一个数据集批量插入我的临时表中,急!!!
- 是否可以不用临时表?
- 比较麻烦的SQL语句
- 急!急!急!如何将字符串拆分后形成集合返回???
- 有没有什么软件能更快更方便地制作oracle数据库安装包?
- 如何找回internal帐号的密码?
- 急:oracle920在redhat7.2下安装结尾建数据库时出现错误!
- system.data.oracleclient requires oracle client software version 8.1.7 or greate
- 新的查询问题,ORACLE我试了代码,没解决,求教
SELECT '1' ID, 'a' CLS, 456 VAL FROM dual
UNION ALL
SELECT '2' , 'a' , 768 FROM dual
union all
SELECT '3' , 'c' , 657 FROM dual
),
bb AS(
SELECT '1' ID, 'b' CLS, 78 VAL FROM dual
UNION ALL
SELECT '2' , 'a' , 67 FROM dual
union all
SELECT '1' , 'a' , 600 FROM dual
union all
SELECT '4' , 'b' , 400 FROM dual
)
from aa left join bb on aa.id=bb.id and aa.cls=bb.cls)
union
(select bb.id, bb.cls, aa.val as val_aa, bb.val as val_bb
from bb left join aa on aa.id=bb.id and aa.cls=bb.cls)
WITH aa AS(
SELECT '1' ID, 'a' CLS, 456 VAL FROM dual
UNION ALL
SELECT '2' , 'a' , 768 FROM dual
union all
SELECT '3' , 'c' , 657 FROM dual
),
bb AS(
SELECT '1' ID, 'b' CLS, 78 VAL FROM dual
UNION ALL
SELECT '2' , 'a' , 67 FROM dual
union all
SELECT '1' , 'a' , 600 FROM dual
union all
SELECT '4' , 'b' , 400 FROM dual
)
select nvl(aa.id,bb.id) id,nvl(aa.cls,bb.cls) cls,aa.val,bb.val from aa full join bb on aa.id=bb.id and aa.cls=bb.cls
order by id,cls
1 1 a 456 600
2 1 b 78
3 2 a 768 67
4 3 c 657
5 4 b 400
full join bb on aa.id = bb.id and aa.cls = bb.cls
order by id