Re: Help newbie unload to converted in oracle

A copy of this was sent to "didier_t" <didier_t_at_wanadoo.fr> (if that email address didn't require changing) On Sat, 4 Dec 1999 14:21:42 +0100, you wrote:

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

i have some scripts to help automate this at the web site in my signature.

as for your specific issue above -- you have a SELECT with no FROM (you forgot " from T" in the select name..... you need to select from a table)

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Dec 04 1999 - 08:05:34 CST