Hi all,
my requirement is to convert the row into cols
The i/p is
col1 col2 col3 col4 col5
***** **** **** **** ****
saturday 30 50 75 80
sunday 25 67 56 10
monday 25 10 34 67
the o/p should be
saturday sunday monday
30 25 25
50 67 10
75 56 34
80 10 67
I am using the oracle 11g database.