rendered paste bodyConnected.
SQL> create table fojtest (field1 integer)
2 /
Table created.
Elapsed: 00:00:00.11
SQL> create table fojtest2 (field2 integer)
2 /
Table created.
Elapsed: 00:00:00.01
SQL> insert into fojtest values(1)
SQL> /
1 row created.
1* insert into fojtest values(3)
1 row created.
Elapsed: 00:00:00.00
SQL> c/3/5
1* insert into fojtest values(5)
SQL> /
1 row created.
Elapsed: 00:00:00.00
SQL> c/5/7
1* insert into fojtest values(7)
SQL> /
1 row created.
Elapsed: 00:00:00.00
SQL> c/7/9
1* insert into fojtest values(9)
SQL> c/9/10
1* insert into fojtest values(10)
SQL> /
1 row created.
Elapsed: 00:00:00.01
SQL> commit
2 /
Commit complete.
Elapsed: 00:00:00.00
SQL> insert into fojtest2 values (2)
2 /
1 row created.
1* insert into fojtest2 values (2)
SQL> c/(2/(4
1* insert into fojtest2 values (4)
SQL> /
1 row created.
Elapsed: 00:00:00.00
SQL> c/4/6
1* insert into fojtest2 values (6)
SQL> /
1 row created.
Elapsed: 00:00:00.00
SQL> c/6/8
1* insert into fojtest2 values (8)
SQL> /
1 row created.
Elapsed: 00:00:00.01
SQL> c/8/10
1* insert into fojtest2 values (10)
SQL> /
1 row created.
Elapsed: 00:00:00.00
SQL> commit
2 /
Commit complete.
Elapsed: 00:00:00.00
SQL> select * from fojtest
2 /
FIELD1
---------------
1
3
5
7
10
5 rows selected.
Elapsed: 00:00:00.06
SQL> select * from fojtest2
2 /
FIELD2
---------------
2
4
6
8
10
5 rows selected.
Elapsed: 00:00:00.00
Elapsed: 00:00:00.04
1 select field1,field2 from fojtest
2 full outer join
3* fojtest2 on field2=field1
SQL> /
FIELD1 FIELD2
--------------- ---------------
10 10
7
5
3
1
6
4
8
2
9 rows selected.
Elapsed: 00:00:00.01
SQL> l
1 select field1,field2 from fojtest
2 full outer join
3* fojtest2 on field2=field1
SQL> 4 where field1<>field2
SQL> /
no rows selected
Elapsed: 00:00:00.03
Wrote file afiedt.buf
1 select field1,field2 from fojtest
2 full outer join
3 fojtest2 on field2=field1
4* where (field1 is null or field2 is null)
SQL> /
FIELD1 FIELD2
--------------- ---------------
7
5
3
1
6
4
8
2
8 rows selected.