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
  • 2
  • 5751

Showing Answers 1 - 2 of 2 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.  

  Was this answer useful?  Yes

KARTHIKA

  • Nov 6th, 2014
 

Use the below code to perform the task

Code
  1.  

  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