posted 17 years ago
I have a table that has columns that are of type varchar2 and number. I need to take the data from these columns and build a flat file that needs to have values specified in certain positions in each row of a text file. I am a newbie for doing this kind of thing. What is the best way to do this? If I use UTL_File and just PUT the values would they be written to the file at the defined length? For example, if defined as varchar2(255), would it be written to the file as a 255 character field or would it be written to the length of the actual value, which may be something like 8? Any example would be greatly appreciated as well. Thanks.
