generate fixed format file [message #319055] |
Thu, 08 May 2008 18:13  |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
I need to create fixed format file using sqlplus. The file is about 200 fields long and containing some columns filled with blank spaces. I want to generate a flat file with the fixed format and filled those columns with blank spaces if it contains blank spaces in the columns of the table.
I have used this approach to create flat file but not able to filled the empty columns with desired blank spaces in it.
spool C:\test.txt
select col1||col2 from tab;
Really appreciate you r valuable time in advance.
|
|
|
|
|
|
|
|
|
|