Use SQL Plus 'COPY' command.
OR
Create TEXT file of that sql query using 'pool' command and load it to other database.