oracle spool

oracle spool

sql> spool output.txt

sql> set echo off;

sql> set feedback on;

sql> set time on;

sql> set timing on;

sql> clear columns;

sql> set pages 40;

sql> set line 200;

sql> column ename format a10;

sql> col job for a10;

sql> col sal for 9,999;

sql> col deptno for 99;

sql> prompt ****************************************

sql> select * from emp;

sql> prompt ****************************************

sql> spool off;

temp.sql

--------------------------------

select * from emp;

--------------------------------

sql> @tmp.sql > output.txt;