spool的用法

 

****************************************
*spool的用法
****************************************
sqlplus命令行状态
―――――――――――――――――――
SET trimspool ON;
SET HEADING OFF;
SET FEEDBACK OFF;
SET linesize 2000;
SET pagesize 0;
SET term off;

define dir_path='d:\temp\bb\';
define extend='.csv';
COLUMN dat1 NEW_VALUE filename;
SELECT DISTINCT a.city_name || '_' || a.station dat1 FROM tmp1 a WHERE a.station = '45000009';

spool &dir_path&filename&extend;
SELECT A.NAME || ',' || A.ADDR || ',' || A.POSTCODE || ',' || A.PROV_NAME || ',' ||
       A.CITY_NAME || ',' || A.STATION || ',' || A.DEPT_NAME
  FROM TMP1 A
 WHERE A.STATION = '45000009'
   AND ROWNUM <= 5;
spool off;

exit;
―――――――――――――――――――