CREATE TABLE temp1(data1 VARCHAR2(1));

create table temp2(data1 varchar2(1));


INSERT INTO temp1 VALUES('A');
INSERT INTO temp1 VALUES('B');
INSERT INTO temp1 VALUES('C');
INSERT INTO temp1 VALUES('D');
INSERT INTO temp1 VALUES('E');

INSERT INTO temp2 VALUES('C');
INSERT INTO temp2 VALUES('D');
INSERT INTO temp2 VALUES('E');
INSERT INTO temp2 VALUES('F');
INSERT INTO temp2 VALUES('G');

I want TO SELECT DATA WHICH IS NOT COMMON TO EITHER OF THE TABLE AS 
--A B F G

existing A b c d e
added    f g c d e

SELECT * FROM
  ( SELECT * FROM TEMP1
  UNION
  SELECT * FROM TEMP2
  )
MINUS
SELECT * FROM
  (SELECT * FROM TEMP2
  INTERSECT
  SELECT * FROM TEMP1
  );

 select * from
(select * from temp1
minus
select * from temp2)
union all
(select * from temp2
minus
select * from temp1);

WITH T AS (
            SELECT DATA1,1 FLAG FROM TEMP1
           UNION ALL
            SELECT DATA1,2 FLAG FROM TEMP2
          )
SELECT  DATA1
  FROM  T
  GROUP BY DATA1
  HAVING COUNT(DISTINCT FLAG) = 1
/

SQL> SELECT DATA1 FROM TEMP1 ORDER BY DATA1
  2  /

D
-
A
A
B
B
C
C
D
D
E
E

10 rows selected.

SQL> SELECT DATA1 FROM TEMP2 ORDER BY DATA1
  2  /

D
-
C
D
E
F
F
G
G

7 rows selected.

SQL> WITH T AS (
  2              SELECT DATA1,1 FLAG FROM TEMP1
  3             UNION ALL
  4              SELECT DATA1,2 FLAG FROM TEMP2
  5            )
  6  SELECT  DATA1
  7    FROM  T
  8    GROUP BY DATA1
  9    HAVING COUNT(DISTINCT FLAG) = 1
 10  /

D
-
A
B
G
F

SQL>

SQL> WITH T AS (
  2              SELECT DATA1,ROW_NUMBER() OVER(PARTITION BY DATA1 ORDER BY 1) FLAG FROM TEMP1
  3             UNION ALL
  4              SELECT DATA1,ROW_NUMBER() OVER(PARTITION BY DATA1 ORDER BY 1) FLAG FROM TEMP2
  5            )
  6  SELECT  DATA1
  7    FROM  T
  8    GROUP BY DATA1,
  9             FLAG
 10    HAVING COUNT(*) = 1
 11    ORDER BY DATA1
 12  /

D
-
A
A
B
B
C
D
E
F
F
G
G

11 rows selected.

SQL>