ORACLE: CREATE TABLE XXX(目标表) AS SELECT * FROM XX(源表);
SQL Server: SELECT * INTO XXX(目标表) FROM XX(源表);