OraFAQ Forum: Client Tools » ROWS to COLUMNS

Home » Other » Client Tools » ROWS to COLUMNS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ROWS to COLUMNS [message #25932]

Tue, 27 May 2003 13:14

Karri
Messages: 33
Registered: May 2001

Member

I have information on rows, but I want it
in to columns. How can I do it?

Example:
Month Day Bonus
Jan 31 100
Feb 28 0
Mar 31 300
Apr 30 50

and s.o.
I want to see only column Month, like this:
Jan Feb Mar Apr

Or like this:
100 0 300 50

This is not a good example because I can
do a WHERE-caluse which make it like I want.
But how can I do it whitout WHERE-clause?
Is it possible or not?

Thanks, Karri

Report message to a moderator