Moving data from 1 table to Another

How can you move the entire data from one table to another? If in same instance and in different instances, both cases?
  • Interview Candidate
  • 6
  • 5678

Showing Answers 1 - 6 of 6 Answers

A MOHAN KUMAR

  • Nov 6th, 2014
 

INSERT INTO < old table > SELECT * FROM < new table >
Note the table should have same column name and their respective data types as old table

Code
  1. INSERT INTO new_table_name SELECT * FROM EMP

  Was this answer useful?  Yes

KARTHIKA

  • Nov 6th, 2014
 

Use the below code to perform the task

Code
  1. INSERT INTO NEWTABLE(COLUMNNAME)

    2. 

  2. SELECT OLDTABLE.COLUMNNAME

    3. 

  3. FROM OLDTABLE WHERE OLDTABLE.COLUMNNAME=CONDITIONVALUE;

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions