| Is it possible to spool data to to fixed format file? [message #1523] |
Wed, 08 May 2002 16:41  |
JAW
Messages: 3
Registered: May 2002
|
Junior Member |
|
|
Hi,
Can anyone tell me if there is a way to spool data from an Oracle table to a fixed format text file? I'm currently concatenating the fields (not using a comma). Null fields are not populating my output file, thereby disrupting the spacing. I need the spaces from the null fields included in the output file.
Thanks for any help.
|
|
|
|
| Re: Is it possible to spool data to to fixed format file? [message #1524 is a reply to message #1523] |
Thu, 09 May 2002 00:10  |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
I assume from your use of the word 'spool' that you are using SQL*Plus to generate this spool file.
The best solutin I can think of it to alter your query to add an NVL around the fields that are causing the problems, to replace them with spaces when null.
There is an SQL*Plus environment varialbe called NULL that controls how nulls display, but it doesn't seem to allow you to display spaces. YMMV.
Hope this helps.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
