oracle如何将两张表合成一张,Oracle：将两个表组合在一起使用不同的列

This is table 1:

col_1 col_2 date_1

----- ----- ------

1 3 2016

2 4 2015

And this is table 2:

col_3 col_4 date_2

----- ----- ------

5 8 2014

6 9 2012

I want a result like this:

col_1 col_2 col_3 col_4 date_1 date_2

----- ----- ----- ----- ------ ------

1 3 NULL NULL 2016 NULL

2 4 NULL NULL 2015 NULL

NULL NULL 5 8 NULL 2014

NULL NULL 6 9 NULL 2012

Any solutions?

解决方案

Using Union All and Null as a different column:

SELECT col_1, col_2, NULL as col_3, NULL as col_4,

date_1, NULL as date_2

FROM table_1

Union All

SELECT NULL, NULL, col_3, col_4, NULL, date_2

FROM table_2