How can we insert into a table by fetching data from more then one table by using only single command

I have 3 tables , same no of columns ,i want to insert whole the data from all these table into a single table,which also having same no of column and the same data type.

Questions by Nitin kumar

Showing Answers 1 - 4 of 4 Answers

japs

  • Jun 13th, 2013
 

by using inline view

  Was this answer useful?  Yes

J. Ali (PL/Sql)

  • Nov 29th, 2013
 

INSERT INTO DYMMY (VAL)
SELECT COLUMN_VALUE val FROM table (tab_contents_nt (1, 2, 3))
UNION ALL
SELECT COLUMN_VALUE val FROM table (tab_contents_nt (4, 5, 6))
UNION ALL
SELECT COLUMN_VALUE val FROM table (tab_contents_nt (7, 8, 9))

sateeshchandra

  • Oct 14th, 2014
 

Code
  1. INSERT ALL

  2.   INTO suppliers (supplier_id, supplier_name) VALUES (1000, IBM)

  3.   INTO suppliers (supplier_id, supplier_name) VALUES (2000, Microsoft)

  4.   INTO customers (customer_id, customer_name, city) VALUES (999999, Anderson Construction, New York)

  5. SELECT * FROM dual;

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions