Re: NEWBIES UNLOAD TO

set colsep '|' trimspool on
select name, city, zipcode from tt;

You are saying your records don't end in CR/LF. That's highly unlikely. I will try to reproduce tomorrow.

Hth,

--
Sybrand Bakker, Oracle DBA
didier_t <didier_t_at_wanadoo.fr> wrote in message news:82h3bv$e3v$1_at_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 - 14:07:49 CST