I tried to extract data form Oracle database in order to build a flat file
(no separator : fixed position used).
I have a commentaire column (varchar2(160)) in which users entred text over 2 lines...
so, using the following command under sqlplus :

SQL> select commentaire from mytab1;

the result is the following :

SQL>
COMMENTAIRE
------------------------------------------------------------
commenaitre1(line1).
commenaitre2.

but I would like to have :
SQL>
COMMENAITRE
-------------------------------------------------------------
commenaitre1(line1).commenaitre2(line2).


Thanks in advance...

Sofiane