This content has been marked as final. Show 4 replies
suppose you have the query as
select * from emp where rowid<3;
write the query in the emp.sql query at any directory like d:\sqljobs\emp.sql
the call make a batch file like sndml.bat and write the following codes
sqlplus scott/tiger@orcl @d:\sqljobs\emp.sql
explorer mailto:firstname.lastname@example.org d"\sqljobs\myrep.txt
or if you are using any mailing software then you can use that..