how to union two tables with different columns in oracle code example
Example: oracle sql union tables with different columns
-- Add extra columns as null for the table having less columns like:
SELECT COL1, COL2, COL3, COL4, COL5 FROM TABLE1
UNION
SELECT COL1, COL2, COL3, NULL AS COL4, NULL AS COL5 FROM TABLE2