Question: what is the difference between union all and full outer join in oracle?
Answer: Difference between Union All and Full outer join. The output record set in UNION ALL contains same number of columns as in the input tables. ... Both the input tables should have the same number of columns and same data types for those columns. But the full outer join concatenates the columns in both the table.