Perl script -need some help.

Posted by benjamin button on Stack Overflow See other posts from Stack Overflow or by benjamin button
Published on 2010-05-01T08:03:59Z Indexed on 2010/05/01 8:07 UTC
Read the original article Hit count: 407

Filed under:
|
|

I have an sql file which will give me an output like below:

10|1
10|2
10|3
11|2
11|4
.
.
.

I am using this in a perl script like below:

my @tmp_cycledef = `sqlplus -s $connstr \@DLCycleState.sql`;

after this above statement,since tmp_cycledef has all the output of the sql query i want to show the output as:

10 1,2,3
11 2,4

how could i do this using perl?

© Stack Overflow or respective owner

Related posts about perl

Related posts about unix