Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> NEWBIES UNLOAD TO
> 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
![]() |
![]() |