Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXTRACt data into one single line

CyrilleNdataFeb 15 2011 — edited Feb 16 2011
Hi dear all,
here is my problem : my goal is to have a single flat txt file with one single row !!!!!!
this being said can someone tell me how to extract data from my oracle table to a txt file , with the info that my table has only one colum (varchar 250) ; and i have 200 rows in that table;
the output has to be only one endless line!!!!!!!!!!
thanks in advance for your great support;
i try with all the possible set ;(set pagesize 0 set tab off SET NEWPAGE 0 SET SPACE 0 set trimspool on set verify off set heading off set recsep off set echo off ....) but no way to make it works!!
This post has been answered by BluShadow on Feb 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2011
Added on Feb 15 2011
14 comments
443 views