Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help newbie unload to converted in oracle
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
![]() |
![]() |