sqlplus c##scott/tiger @runsql.sql

1 conn c##scott/tiger
2 --写你的sql语句
3 select * from (select * from dept order by rownum) where rownum<2;
4 commit;
5 pause;
6 exit;

1 conn c##scott/tiger
2 spool d:\output.txt
3 select * from (select * from dept order by rownum) where rownum<2;
4 commit;
5 spool off;
6 pause;
7 exit;