Contents

1 覦覯1
2 覦覯2


1 覦覯1 #

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

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
*/