利用Oracle之SQLPLUS的spool导出文本文件的数据格式问题

Question

SQL> help set SET
 --- Sets a system variable to alter the SQL*Plus environment settings
 for your current session, for example:
     -   display width for data
     -   turn on HTML formatting
     -   enabling or disabling printing of column headings
     -   number of lines per page In iSQL*Plus, you can also use the System Variables screen to set
 system variables. SET system_variable value where system_variable and value represent one of the following clauses:   APPI[NFO]{OFF|ON|text}                  *NEWP[AGE] {1|n|NONE}
   ARRAY[SIZE] {15|n}                       NULL text
   AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n}      NUMF[ORMAT] format
   AUTOP[RINT] {OFF|ON}                     NUM[WIDTH] {10|n}
   AUTORECOVERY {ON|OFF}                    PAGES[IZE] {24|n}
   AUTOT[RACE] {OFF|ON|TRACE[ONLY]}        *PAU[SE] {OFF|ON|text}
     [EXP[LAIN]] [STAT[ISTICS]]             RECSEP {WR[APPED] |
   BLO[CKTERMINATOR] {.|c}                    EA[CH]|OFF}
   CMDS[EP] {;|c|OFF|ON}                    RECSEPCHAR {_|c}
   COLSEP {_|text}                          SERVEROUT[PUT] {OFF|ON}
   COM[PATIBILITY] {V7|V8|NATIVE}             [SIZE n] [FOR[MAT]
   CON[CAT] {.|c|OFF|ON}                      {WRA[PPED] |
   COPYC[OMMIT] {0|n}                         WOR[D_WRAPPED] |
   COPYTYPECHECK {OFF|ON}                     TRU[NCATED]}]
   DEF[INE] {&|c|OFF|ON}                   *SHIFT[INOUT] {VIS[IBLE] |
   DESCRIBE [DEPTH {1|n|ALL}]                 INV[ISIBLE]}
     [LINENUM {ON|OFF}] [INDENT {ON|OFF}]  *SHOW[MODE] {OFF|ON}
   ECHO {OFF|ON}                           *SQLBL[ANKLINES] {ON|OFF}
  *EDITF[ILE] file_name[.ext]               SQLC[ASE] {MIX[ED] |
   EMB[EDDED] {OFF|ON}                        LO[WER] | UP[PER]}
   ESC[APE] {\|c|OFF|ON}                   *SQLCO[NTINUE] {> | text}
   FEED[BACK] {6|n|OFF|ON}                 *SQLN[UMBER] {OFF|ON}
   FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL}  SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
  *FLU[SH] {OFF|ON}                        *SQLPRE[FIX] {#|c}
   HEA[DING] {OFF|ON}                      *SQLP[ROMPT] {SQL>|text}
   HEADS[EP] {||c|OFF|ON}                   SQLT[ERMINATOR]
   INSTANCE [instance_path|LOCAL]             {;|c|OFF|ON}
   LIN[ESIZE] {80|n} ({150|n} iSQL*Plus)   *SUF[FIX] {SQL|text}
   LOBOF[FSET] {n|1}                        TAB {OFF|ON}
   LOGSOURCE [pathname]                     TERM[OUT] {OFF|ON}
   LONG {80|n}                              TI[ME] {OFF|ON}
   LONGC[HUNKSIZE] {80|n}                   TIMI[NG] {OFF|ON}
   MARK[UP] HTML [ON|OFF]                   TRIM[OUT] {OFF|ON}
     [HEAD text] [BODY text] [TABLE text]   TRIMS[POOL] {ON|OFF}
     [ENTMAP {ON|OFF}]                      UND[ERLINE] {-|c|ON|OFF}
     [SPOOL {ON|OFF}]                       VER[IFY] {OFF|ON}
     [PRE[FORMAT] {ON|OFF}]                 WRA[P] {OFF|ON} An asterisk (*) indicates the SET option is not supported in iSQL*Plus.使用 set echo off

Answer 1

如果要空行的话 用 ；set echo off
spool c:\test.txt;
select a||','||b||','||c||','||d||','||e||','||f||','||g from test;
;
spool off

Answer 2

fjmingyang(努力升级) 大虾，谢谢您的回复我用了set echo off，可是结果还如原来一样。最后保证一个空行的问题是可行的，谢谢。还有大虾能给出解决方法吗？期待ing

Answer 3

set heading off
set pagesize 0
set feedback off  
set trimout on          
set trimspool on   
set termout off  
spool c:\test.txt
select a||',' ||b||',' ||c||',' ||d||',' ||e||',' ||f||',' ||g    from test;
spool off;
在spool off下空一行或者加一"/"。再试试