Create View with data (not repeated) from 2 tables with the same structure
<p>In a oracle database, I have 2 tables with the same structure (same columns). One is being migrated to the other. The thing is that I need to create a view that reads records from the 2 tables so that during migration it's possible to read all records. In case there are repeated records, only the ones from table 1 should be displayed in the view.</p>

<p>Table 1</p>

<pre><code>USER_ID       START_DATE       END_DATE
1             2015-08-12       2015-12-08
2             2015-02-25       2015-06-01
3             2015-04-14       2015-09-21
</code></pre>

<p>Table 2</p>

<pre><code>USER_ID       START_DATE       END_DATE
2             2015-02-25       2015-06-01
4             2015-12-20       2016-01-13
</code></pre>

<p>The view should contain the following data:</p>

<pre><code>USER_ID       START_DATE       END_DATE
1             2015-08-12       2015-12-08
2             2015-02-25       2015-06-01
3             2015-04-14       2015-09-21
4             2015-12-20       2016-01-13
</code></pre>

<p>Is this possible? </p>

<p>Thanks!</p>