sql union fewer fields 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