Loading Between Tables That Have the Same Schema

You can easily move data from an external table to a database table if the tables have the same schema.

You can load data from one table to another table that has the same schema (for example, worldemp) with a simple INSERT statement.

INSERT INTO worldemp SELECT * FROM emp_ext;