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


댓글수0