Output

[neskin]

Hi there,
I have fields
week_no field1 field2 field3 field4
1 10 20 30 40
2 10 10 10 10
3 20 20 20 20
4 30 30 30 30
5 40 40 40 40
...
i need to display

week_no 1 2 3 4 5 ....
field1 10 10 20 30 40
field2 20 10 20 30 40
field3 30 10 20 30 40
field4 40 10 20 30 40


thank u
nat

 

[KenCunningham]

Hi Nat. There are several threads which have dealt with similar scenarios - see Thread186-1230282

For any others, try a keyword search for 'columns' in this and the 9i Forum. HTH.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.