REM MAJOR.BAT

sqlplus -s scott/tiger@ora10lp @major.sql

type major.txt

REM MAJOR.SQL

set termout off

spool major.txt

select ename, job, sal
from emp
where deptno = 10;

spool off;

exit;

C:\TEMP>major

C:\TEMP>sqlplus -s scott/tiger@ora10lp @major.sql

C:\TEMP>type major.txt

ENAME      JOB              SAL

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

CLARK                      2450

KING                       5000

MILLER                     1300



C:\TEMP>