in reply to Re^2: extract string columns with perl
in thread extract string columns with perl

Well, I am using something similar (although not sure for every detail). One additional statement you could use to get a CSV is: 
set colsep ,

[download]
Also, you may want to use the trim function in your select statement.

Replies are listed 'Best First'.
Re^4: extract string columns with perl
by juanito23 (Novice) on Apr 16, 2014 at 08:46 UTC
    Nice one thanks for the hint. I checked the oracle linesize limit and set it to 32767 which is the max.

    Looks to help with the csv file format and now I sorted it.

    Thanks to all!
[reply]

In Section Seekers of Perl Wisdom