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.
Thanks,
Badal