SQLPLUS Question : Urgent ...

[Sofiane]

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

[pipo]

I guess you'll have to use PL/SQL to go through your table and build a line using ||

PS :
SQL> select 'a' || '.' || 'b' from dual;
> a.b

[Sofiane]

I was not clear in my explanation.

Suppose that there is only 1 record in my table.

mytab definition
******
C1 varchar2(1) notnull
Commentaire varchar2(200)
C3 number not null

SQL> select count(*) from mytab;
SQL>
count(*)
----------
1

SQL> spool /tmp/mytab.lst
SQL> select * from mytab;
SQL> spool off

vi /tmp/mytab.lst (with :set nu)
1: Ycommenaitre1
2: commentaire2 N



I would like to have

Ycommentaire1commenaitre2N

Y : for C1 column
commenaitre1commenaitre2 : for Commenaitre column
N : for C3 column

Any solution

Sofiane

[pipo]

ahhhh, ok, it's just a linesize problem :

set linesize 1500
spool ...
select ...
spool off


and you're done

[reydp]

I though there is a need to use substr and pipeline.
I even try it myself. geeeh its just setting linesize allright.