position file

[tarek_gh]

Hi there,
i'm new in oracle and sql.
I have to create a file that queries an oracle table.
This file must be structured in positions. I explain better:
For ex,from position 1 to 10 there must be a field that contains certain values, from
11 to 20 another field, 21 to 21 another field and so on...
I have to create this file with fixed fields size. Is there any function that does this, or is there any way to do it??
(can you make me an example??)
Thanks in advance....

[gandolf989]

You can use the col colname format command

SQL> column dummy format a40
SQL> select * from dual;

DUMMY
----------------------------------------
X

SQL> column dummy format a100
SQL> select * from dual;

DUMMY
----------------------------------------------------------------------------------------------------
X