AQT provides a number of ways of moving data from one table to another.
Export as Inserts. Using this, AQT will export a table/query as a series of Insert statements. This can be used for loading data into another table.
Data Loader. The Data Loader is AQT's main tool for loading data into tables. The data can comes from another table, in either the same database or another database, from a csv file, or from an Excel worksheet.
Export to Table. The Run SQL window has an option Export > Export to Table. This will export the results of the query to a table (which can be in another database). The table can be created.
This function invokes the Data Loader in the background.
Load Multiple Tables. This allows you to load multiple tables (such as all the tables in a schema) in a single operation. The data for the tables can come from another schema, a set of files in a directory or worksheets in an Excel file.
This function invokes the Data Loader in the background.
