[Oracle] sqlplus 엑셀 export

sqlplus 로 sql 파일을 실행해서 엑셀파일로 저장

C:\test2.sql

set echo off set feed off set termout off set markup html on spool on column filename new_val filename select 'C:\TEST2_'||to_char(sysdate, 'YYYYMMDD')||'.xls' filename from dual; spool &filename SELECT * FROM AATEST ; spool off set markup html off  quit

cmd

C:\> sqlplus username/password@TNS_name @C:\test2.sql