Delimitador de colunas

[MuLtAnI]

dae galera,

alguém sabe como colocar uma string para separar as colunas que retornam de uma consulta sql com mais de uma coluna?

tipo

Selecionar tudo

select cdpro, depro from cadpro
00001 - peteca

[]'s

[dr_gori]

Se você quiser delimitar os campos, pode usar o seguinte:

Selecionar tudo

SQL> SET COLSEP '|'
SQL> select * from emp;

     EMPNO|ENAME     |JOB      |       MGR|HIREDATE 
----------|----------|---------|----------|---------
      7369|SMITH     |CLERK    |      7902|17-DEC-80
      7499|ALLEN     |SALESMAN |      7698|20-FEB-81
      7521|WARD      |SALESMAN |      7698|22-FEB-81
      7566|JONES     |MANAGER  |      7839|02-APR-81
      7654|MARTIN    |SALESMAN |      7698|28-SEP-81
      7698|BLAKE     |MANAGER  |      7839|01-MAY-81
      7782|CLARK     |MANAGER  |      7839|09-JUN-81
      7788|SCOTT     |ANALYST  |      7566|19-APR-87
      7839|KING      |PRESIDENT|          |17-NOV-81
      7844|TURNER    |SALESMAN |      7698|08-SEP-81
      7876|ADAMS     |CLERK    |      7788|23-MAY-87
      7900|JAMES     |CLERK    |      7698|03-DEC-81
      7902|FORD      |ANALYST  |      7566|03-DEC-81
      7934|MILLER    |CLERK    |      7782|23-JAN-82

14 rows selected.

Como eu descobri isso? Recorri ao HELP ONLINE do SQL*PLUS.
http://glufke.net/oracle/viewtopic.php?t=10

Veja exemplo:

Selecionar tudo

SQL> @help
Digite o help (Em branco para mostrar tópicos): 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.


58 rows selected.

SQL>