Insert the query results of one table in Oracle to table 1 and Oracle database. Generate and import the query results of one table to a new table. Www.2cto.com. For example, if only table A is available, query table A and import the result to table B. Use the following SQL statement: the SQL code create table B as select * from A 2. The Oracle Database supports importing the query results to another table. For example, there are two tables A and B 1) if the two tables have the same structure but the field type to be inserted is the same: www.2cto.com (1) insert all the field data of Table A into Table B: SQL code insert into B select * from A; (2) insert data of some fields in Table A into Table B: SQL code insert into B (field name) (select field name from A) 2) If you do not add A schema before the table name in the same schema, for example, schema X and Y: SQL code insert into Y. B select * from X. A