Connected.
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.