-
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....
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|