export the query results to the file and same file is should be imported to another tableWhy do you need the file? What's wrong with "insert ... select ..."?
If you're talking about copying to a different database, then import and export exist in Oracle too!
If so look into the query parameter of data pump. This allows you to filter the rows as needed:
https://oracle-base.com/articles/10g/oracle-data-pump-10g#content-and-query