CSV파일로 Export방법

Contents

1 방법1

2 방법2

[edit]

1 방법1 #

set echo off
set feedback off
set pagesize 0
Spool backup.csv;
Select cellno||','||calldate||','||answertime from temp;
Spool off;

[edit]

2 방법2 #

set colsep ";"
set heading off

select empno, ename, job, deptno
from emp
where deptno = 10;
/* 결과
7782;CLARK     ;MANAGER  ;        10
7839;KING      ;PRESIDENT;        10
7934;MILLER    ;CLERK    ;        10
*/