Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help newbie unload to converted in oracle

Re: Help newbie unload to converted in oracle

From: didier_t <didier_t_at_wanadoo.fr>
Date: Sat, 4 Dec 1999 15:35:27 +0100
Message-ID: <82b8rv$nlg$1@wanadoo.fr>


Correction
> Please, i want create the function informix unload to in oracle.
> Example : unload to "toto.txt"
> select name[1,32],city,zipcode from tt;
> This code not functionnal the end of string is bad
> set linesize 150
> spool toto.txt
> select name||'|'||city||'|'||zipcode||'|'|| from tt;
> spool off
>
> Thanks
>
> i want

aaaaa|ny|5454|
|bbbb|nn|6455|
and i have
aaaaa|ny|5454|space space space
bbbb|nn|6455|space space space
exactly i want an function for create
text delimited with | .
this record finished without 0Dh 0Ah
excuse me my english i'm french Received on Sat Dec 04 1999 - 08:35:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US