<div>
I think that setting long and linesize should get the output you wanted.<br />
<br />
Try it and if you are not getting the data output format you wanted, can you post the sample data for 1 record in the table and the expected output.<br />
<br />
Also put the current output you are getting so that we can try to help with that to get the expected output.<br />
<br />
Thanks
</div>


I think that setting long and linesize should get the output you wanted.

Try it and if you are not getting the data output format you wanted, can you post the sample data for 1 record in the table and the expected output.

Also put the current output you are getting so that we can try to help with that to get the expected output.

Thanks

<div>
Forced accept.<br />
<br />
Computer101<br />
Community Support Moderator
</div>


Forced accept.

Computer101
Community Support Moderator

<div>
<div class="content wysiwyg-content">
Hi All!,<br />
<br />
I wonder if someone dealt with this problem. I have to export into a csv file a long data type field. I work with Oracle 7.3<br />
<br />
&nbsp; &nbsp;set termout off<br />
&nbsp; &nbsp;set hea off<br />
&nbsp; &nbsp;set pagesize 0<br />
&nbsp; &nbsp;spool c:\export.csv<br />
&nbsp; &nbsp;select &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PR_PK||','||PR_DESC<br />
&nbsp; &nbsp;from F_PROJECT_FILE;<br />
&nbsp; &nbsp;spool off &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
Thank you.<br />
<br />
<br />
Claudio
</div>
</div>


Hi All!,

I wonder if someone dealt with this problem. I have to export into a csv file a long data type field. I work with Oracle 7.3

   set termout off
   set hea off
   set pagesize 0
   spool c:\export.csv
   select 	PR_PK||','||PR_DESC
   from F_PROJECT_FILE;
   spool off	

Thank you.


Claudio

Export Long data type to csv

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.