DB/Oracle
[Oracle] sqlplus 엑셀 export
냐옴
2019. 3. 21. 16:56
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 |