[Oracle] SQL to Excel

오라클에서 쿼리의 결과를 엑셀로 바로 저장하기.


spool c:\export_date.xls; 
set markup html on; 
set pagesize 9999; 

select 
substr(mdn, 1,3)||'-'||substr(mdn, 4, 4)||'-'||substr(mdn, 8,4) mdn, 
to_char(to_date(reg_date||reg_time, 'yyyymmddhh24miss'), 'yyyy.mm.dd hh24:mi:ss') datetime 
from mo_stat order by reg_Date, reg_time; 

set markup html off; 
spool off;