Creating a database table in Oracle from multiple sources

Question

I am getting data from two different table sources. What is the best way to combine them into one?

For example:

table one has the following columns:

date | time | exchange

table two has the following columns:

date | time | price | position

I want to combine them so I can create a table that has:

date | time | exchange | position | price

Sometimes position and exchange columns are empty. What is the best way to create this new table?

what's the problem about having these fields empty? – Sebas Nov 14 '12 at 15:53 — Sebas, Nov 14 '12 at 15:53

score 3 · Accepted Answer · edited May 23 '17 at 11:43

I would recommend further reading into SQL JOINs. SQL Joins

Then read up on how Views represent data from multiple tables: What is a View in Oracle?

Then read up on how SQL UNION combines results from multiple tables: http://www.orafaq.com/wiki/Union

This just scratches the surface. All of these will solve your requirement with various benefits and draw backs.

score 0 · Answer 2 · answered Nov 14 '12 at 15:54

0

I would probably suggest using a join table as well, althought its not clear how your tables are truly related. You should understand Normalization

answered Nov 14 '12 at 15:54

Antarr Byrd

2 Answers2