[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脚本.
