I want to send an email, the output of a simple SQL query in oracle 10g

simple:
I would use UTL_MAIL:

http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10802/u_mail.htm

If the message is larger than 32K, you'll need to use UTL_SMTP.

Here's the example of utl_smtp to send an email:

http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10802/u_smtp.htm#1006619

I am planning to store the output of a query into a text file, and then send using bmail, I will use task scheduler to initiate the batch file where all the commands would be written, so can you tell me how to store output of a query into a text file?