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 -> NEWBIES UNLOAD TO

NEWBIES UNLOAD TO

From: didier_t <didier_t_at_wanadoo.fr>
Date: Mon, 6 Dec 1999 20:38:11 +0100
Message-ID: <82h3bv$e3v$1@wanadoo.fr>


> 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
AND this record finished without 0Dh 0Ah

exactly i want an function for create
text delimited with | .
excuse me my english i'm french Received on Mon Dec 06 1999 - 13:38:11 CST

Original text of this message

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