[20140506]SQL Developer生成CSV檔案.txt

[20140506]SQL Developer生成CSV檔案.txt

今天看別人使用SQL Developer,生成CSV檔案.
執行如下:

select /*csv*/ * from emp;
--按F5,輸出如下: 註解csv沒有加號.好像僅僅輸入小寫才有效.並且不能有任何空格.

"EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO"
7369,"SMITH","CLERK",7902,17-12月-80,800,,20
7499,"ALLEN","SALESMAN",7698,20-2月 -81,1600,300,30
7521,"WARD","SALESMAN",7698,22-2月 -81,1250,500,30
7566,"JONES","MANAGER",7839,02-4月 -81,2975,,20
7654,"MARTIN","SALESMAN",7698,28-9月 -81,1250,1400,30
7698,"BLAKE","MANAGER",7839,01-5月 -81,2850,,30
7782,"CLARK","MANAGER",7839,09-6月 -81,2450,,10
7788,"SCOTT","ANALYST",7566,19-4月 -87,3000,,20
7839,"KING","PRESIDENT",,17-11月-81,5000,,10
7844,"TURNER","SALESMAN",7698,08-9月 -81,1500,0,30
7876,"ADAMS","CLERK",7788,23-5月 -87,1100,,20
7900,"JAMES","CLERK",7698,03-12月-81,950,,30
7902,"FORD","ANALYST",7566,03-12月-81,3000,,20
7934,"MILLER","CLERK",7782,23-1月 -82,1300,,10

另外如果執行如下
select /*html*/ * from emp;
--生成的html好像apex程式碼,我不懂這些東西,在瀏覽器可以支援簡單查詢.

實際上在sqlplus下,執行:

SCOTT@test> set colsep "|"
SCOTT@test> select  * from scott.dept1;

    DEPTNO|DNAME         |LOC
----------|--------------|-------------
        50|TEST          |BBBBB
        10|ACCOUNTING    |NEW YORK
        20|RESEARCH      |DALLAS
        30|SALES         |CHICAGO
        40|OPERATIONS    |BOSTON
        60|MMMM          |ZZZZZZ

6 rows selected.

--實際上在toad下也很容易實現,我更加喜歡在toad下使用,它還可以生成insert指令碼.