Perl script -need some help.
- by benjamin button
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?