[20190731]spool cvs in 12cR2.txt

来源:这里教程网 时间:2026-03-03 14:03:00 作者:

[20190731]spool cvs in 12cR2.txt --//12c支持cvs输出。语法如下: SET MARKUP CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}] 1.环境: SCOTT@test01p> @ ver1 PORT_STRING                    VERSION        BANNER                                                                               CON_ID ------------------------------ -------------- -------------------------------------------------------------------------------- ---------- IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0 2.测试: SCOTT@test01p> SET MARKUP CSV ON SCOTT@test01p> select * from dept; "DEPTNO","DNAME","LOC" 10,"ACCOUNTING","NEW YORK" 20,"RESEARCH","DALLAS" 30,"SALES","CHICAGO" 40,"OPERATIONS","BOSTON" --//取消字符串的引号。 SCOTT@test01p> SET MARKUP CSV ON QUOTE OFF SCOTT@test01p> select * from dept; DEPTNO,DNAME,LOC 10,ACCOUNTING,NEW YORK 20,RESEARCH,DALLAS 30,SALES,CHICAGO 40,OPERATIONS,BOSTON --//使用|作为分割符号。 SET MARKUP CSV ON DELIMITER | SCOTT@test01p> select * from dept; DEPTNO|DNAME|LOC 10|ACCOUNTING|NEW YORK 20|RESEARCH|DALLAS 30|SALES|CHICAGO 40|OPERATIONS|BOSTON SCOTT@test01p> set head off SCOTT@test01p> select * from dept; 10|ACCOUNTING|NEW YORK 20|RESEARCH|DALLAS 30|SALES|CHICAGO 40|OPERATIONS|BOSTON

相关推荐