Sqlplus-导出和假脱机结果 [英] Sqlplus - Export and spool result
本文介绍了Sqlplus-导出和假脱机结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用shell脚本在sqlplus中执行导出
I am using shell script to execute an export in sqlplus
假脱机:
SET echo off
SET linesize 32767
SET LONG 1000
SET LONGCHUNKSIZE 1000
SET wrap off
SET heading off
SET colsep ';'
SET pagesize 0
SET feed off
SET termout off
SET trimspool off
SELECT
AUTO_SEQ.nextval as ROW_ID,
..
..
结果:
29419987;FOR_IMPORT;1000 ;KR 19 F 65 73 ;KR 19 F 65 73, 47001, 47000 ;SANTA MARTA ;Cargado por EIM en 03-MAY-17 ;KR 19 F 65 73, 47001, 47000 ;KR 19 F 65 73, 47001, 47000 ;KR 19 F 65 73, 47001, 47000 ;MAGDALENA ; ;COLOMBIA; ; ; ; ; ;Y;N;Y
结果在数据之前和/或之后有许多空白,所以我的问题是如何删除它们?
The result has many blanks before and/or after the data, so my question is how can I remove them ?
谢谢.
推荐答案
只需掌握最新版本的SQL Plus,一切都会好起来的
Just grab yourself the current version of SQL Plus, and you'll be good to go
SQL> set markup csv on
SQL> select * from scott.emp;
"EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO"
7369,"SMITH","CLERK",7902,"17-DEC-80",800,,20
7499,"ALLEN","SALESMAN",7698,"20-FEB-81",1600,300,30
7521,"WARD","SALESMAN",7698,"22-FEB-81",1250,500,30
7566,"JONES","MANAGER",7839,"02-APR-81",2975,,20
7654,"MARTIN","SALESMAN",7698,"28-SEP-81",1250,1400,30
7698,"BLAKE","MANAGER",7839,"01-MAY-81",2850,,30
7782,"CLARK","MANAGER",7839,"09-JUN-81",2450,,10
7788,"SCOTT","ANALYST",7566,"09-DEC-82",3000,,20
7839,"KING","PRESIDENT",,"17-NOV-81",5000,,10
7844,"TURNER","SALESMAN",7698,"08-SEP-81",1500,,30
7876,"ADAMS","CLERK",7788,"12-JAN-83",1100,,20
7900,"JAMES","CLERK",7698,"03-DEC-81",950,,30
7902,"FORD","ANALYST",7566,"03-DEC-81",3000,,20
7934,"MILLER","CLERK",7782,"23-JAN-82",1300,,10
这篇关于Sqlplus-导出和假脱机结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文