Question

oracle 如何对比一个表的字段值与另一个表的字段值，并把不同查询出来

Answer 1

两张表的全连接，下面两个自己试一下吧
select
case when b.dsc=null then a.dsc else end as adsc
case when a.dsc=null then b.dsc else end as bdsc
from a full join b
on a.dsc=b.dsc
或
select * from
(
select a.dsc as adsc,b.dsc as bdsc
from a full join b
on a.dsc=b.dsc
) ab
where ab.adsc=null or ab.bdsc=null

Answer 2

(SELECT a.deviceno FROM gcsiuclaim a
MINUS
SELECT b.deviceno FROM gcsiu b where b.deviceno is not null)
UNION ALL
(SELECT b.deviceno FROM gcsiu b where b.deviceno is not null
MINUS
SELECT a.deviceno FROM gcsiuclaim a)

Answer 3

SELECT
a.dsc as adsc,b.dsc as bdsc
FROM a, b
WHERE a.dsc != b.dsc
试试吧

追问

不行啊