I need to form the equivalent of a Union Join in Oracle 8i, even though a Union Join doesn't appear to be supported in 8i. I might be able to manipulate a Full Outer Join to get the results I need ...

We created two new tables departments and employees for the demonstration using Sample-tables.sql script. The SQL script is underfollowed. -- Create DEPARTMENTS table CREATE TABLE DEPARTMENTS ( ...