Oralce 에서 쿼리결과 추출 후 파일로 작성하기 console에서

a.sql 파일 내용
=========================================================
SET NEWPAGE 0
SET SPACE 0
SET TRIMSPOOL ON
SET LINESIZE 3000
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET TAB OFF
SET TERMOUT OFF
SET FEED OFF
SET COLSEP '|'    --컬럼구분자를 파이프로 설정함
SPOOL /oradata/test.txt;
select
CONTROLNUMBER AS MIN_DT12,
(
  CASE
    WHEN AREA_INDEX = 336111 THEN 701
    WHEN AREA_INDEX = 336112 THEN 702
    WHEN AREA_INDEX = 336121 THEN 711
    WHEN AREA_INDEX = 336122 THEN 712
    WHEN AREA_INDEX = 336124 THEN 713
    WHEN AREA_INDEX = 336125 THEN 714
    WHEN AREA_INDEX = 336127 THEN 715
    WHEN AREA_INDEX = 336128 THEN 716
    WHEN AREA_INDEX = 336131 THEN 721
    WHEN AREA_INDEX = 336132 THEN 722
    WHEN AREA_INDEX = 336133 THEN 723
    WHEN AREA_INDEX = 336134 THEN 724
    WHEN AREA_INDEX = 336352 THEN 731
    WHEN AREA_INDEX = 336353 THEN 732
    WHEN AREA_INDEX = 336354 THEN 733
    WHEN AREA_INDEX = 336355 THEN 734
    WHEN AREA_INDEX = 336441 THEN 741
  END
) AS MIN_LOC,
'1' AS MIN_ITEM,
SO2 AS MIN_VALUE,
0 AS MIN_OVER,
SSO2 AS MIN_STTE,
'R' AS MIN_FLAG,
TO_CHAR(SYSDATE, 'YYYYMMDDHH24miss') AS MIN_SAVE_DT14
from five_table
where 1=1
AND CONTROLNUMBER LIKE '2015%'
AND AREA_INDEX IN ('336111', '336112', '336121', '336122', '336124',
                '336125', '336127', '336128', '336131', '336132',
                '336133', '336134', '336352', '336353', '336354',
                '336355', '336441')
SPOOL ON
QUIT
=========================================================
SQL>a.sql 로실행하면 됨