echo "select 1 from dual;" | sqlplus user/password@database | mail -s "Result of your query" simon@brunningonline.net
I love Unix, me.