This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
If it is a one time process, then you could export the file as Jeanne suggested.
If this would be called frequently, then following are some options:
1) Write a procedure that writes data to a file using utl_file package
2) Write a program (eg using JDBC) that iterates through the resultset and writes data to a file using BufferedWriter.