Styjun

Can you cover a cube with copies of this shape?

What is the color associated with lukewarm?

I have found ports on my Samsung smart tv running a display service. What can I do with it?

Catching a robber on one line

At what temperature should the earth be cooked to prevent human infection?

What could be the physiological mechanism for a biological Geiger counter?

Is there a term for someone whose preferred policies are a mix of Left and Right?

Is swap gate equivalent to just exchanging the wire of the two qubits?

Can I drive in EU states and Switzerland with German proof of a surrendered U.S. license?

Leaving job close to major deadlines

How do I become a better writer when I hate reading?

Using roof rails to set up hammock

How to address players struggling with simple controls?

Are their examples of rowers who also fought?

My student in one course asks for paid tutoring in another course. Appropriate?

High-end PC graphics circa 1990?

Leveraging cash for buying car

How do I run a script as sudo at boot time on Ubuntu 18.04 Server?

Background for black and white chart

Is it a bad idea to have a pen name with only an initial for a surname?

Redirecting output only on a successful command call

How useful is the GRE Exam?

How can I maintain game balance while allowing my player to craft genuinely useful items?

How can this shape perfectly cover a cube?

How to insert data from multi tables to one table in Oracle?

What is the difference between UNION and UNION ALL?How to select the nth row in a SQL database table?Best way to do multi-row insert in Oracle?How do I find duplicate values in a table in Oracle?Get list of all tables in Oracle?Oracle: how to UPSERT (update or insert into a table?)How can I get column names from a table in Oracle?How do I limit the number of rows returned by an Oracle query after ordering?Oracle: If Table ExistsOracle SQL: Update a table with data from another tableSQL Insert into table only if record doesn't exist

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I'd a trouble with inserting data from 3 table:
A (id, name), B (id, name), C (id, name). They have the same field like that.
How can I insert data from 3 tables above into table D (id, name)?

oracle oracle11g sql-insert

share|improve this question

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

asked Mar 25 at 3:56

leebongeeleebongee

375

add a comment | 

1

I'd a trouble with inserting data from 3 table:
A (id, name), B (id, name), C (id, name). They have the same field like that.
How can I insert data from 3 tables above into table D (id, name)?

oracle oracle11g sql-insert

share|improve this question

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

asked Mar 25 at 3:56

leebongeeleebongee

375

add a comment | 

I'd a trouble with inserting data from 3 table:
A (id, name), B (id, name), C (id, name). They have the same field like that.
How can I insert data from 3 tables above into table D (id, name)?

oracle oracle11g sql-insert

share|improve this question

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

asked Mar 25 at 3:56

leebongeeleebongee

375

share|improve this question

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

asked Mar 25 at 3:56

leebongeeleebongee

375

share|improve this question

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

asked Mar 25 at 3:56

leebongeeleebongee

375

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

edited Mar 25 at 5:02

Barbaros Özhan

17.6k71634

asked Mar 25 at 3:56

leebongeeleebongee

375

asked Mar 25 at 3:56

leebongeeleebongee

375

1 Answer
1

active

oldest

votes

4

You could use UNION or UNION ALL

INSERT INTO table_d(id, name)
SELECT id, name
FROM table_a
UNION ALL 
SELECT id, name
FROM table_b
UNION ALL 
SELECT id, name
FROM table_c; 

If you want to remove duplicate rows in 3 tables, change UNION ALL to UNION. Refer information about union vs union all

share|improve this answer

edited Mar 25 at 6:43

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks so much :) It's very clear and nice.
  
  – leebongee
  Mar 25 at 4:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ThúyTrần you're welcome. Nice day programming!
  
  – Pham X. Bach
  Mar 25 at 4:17
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  You're missing one UNION (ALL) for table_c (and didn't say when to use UNION, and when UNION ALL).
  
  – Littlefoot
  Mar 25 at 6:05
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55331076%2fhow-to-insert-data-from-multi-tables-to-one-table-in-oracle%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

4

You could use UNION or UNION ALL

INSERT INTO table_d(id, name)
SELECT id, name
FROM table_a
UNION ALL 
SELECT id, name
FROM table_b
UNION ALL 
SELECT id, name
FROM table_c; 

If you want to remove duplicate rows in 3 tables, change UNION ALL to UNION. Refer information about union vs union all

share|improve this answer

edited Mar 25 at 6:43

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks so much :) It's very clear and nice.
  
  – leebongee
  Mar 25 at 4:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ThúyTrần you're welcome. Nice day programming!
  
  – Pham X. Bach
  Mar 25 at 4:17
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  You're missing one UNION (ALL) for table_c (and didn't say when to use UNION, and when UNION ALL).
  
  – Littlefoot
  Mar 25 at 6:05
  

  
  
  
  

add a comment | 

4

You could use UNION or UNION ALL

INSERT INTO table_d(id, name)
SELECT id, name
FROM table_a
UNION ALL 
SELECT id, name
FROM table_b
UNION ALL 
SELECT id, name
FROM table_c; 

If you want to remove duplicate rows in 3 tables, change UNION ALL to UNION. Refer information about union vs union all

share|improve this answer

edited Mar 25 at 6:43

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks so much :) It's very clear and nice.
  
  – leebongee
  Mar 25 at 4:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ThúyTrần you're welcome. Nice day programming!
  
  – Pham X. Bach
  Mar 25 at 4:17
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  You're missing one UNION (ALL) for table_c (and didn't say when to use UNION, and when UNION ALL).
  
  – Littlefoot
  Mar 25 at 6:05
  

  
  
  
  

add a comment | 

You could use UNION or UNION ALL

INSERT INTO table_d(id, name)
SELECT id, name
FROM table_a
UNION ALL 
SELECT id, name
FROM table_b
UNION ALL 
SELECT id, name
FROM table_c; 

If you want to remove duplicate rows in 3 tables, change UNION ALL to UNION. Refer information about union vs union all

share|improve this answer

edited Mar 25 at 6:43

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630

INSERT INTO table_d(id, name)
SELECT id, name
FROM table_a
UNION ALL 
SELECT id, name
FROM table_b
UNION ALL 
SELECT id, name
FROM table_c; 

share|improve this answer

edited Mar 25 at 6:43

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630

answered Mar 25 at 4:00

Pham X. BachPham X. Bach

4,10321630