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