spooling a CLOB data
The app team needs to download this table into a file. The file is to be massaged and loaded into another database (oracle or teradata). The app team is using the following command to create a file
select column1 || ',' || column2 || ',' ... from table
This is spooled into a flat file. The issue is that one table record does not fit into one line in the file. In a quick test that I did the number of rows was 9 and the number of records in the file was 32. Is there a way to make each output row from the table to 'fit' one row in the output file?