Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need help Reformatting output
RE: Active sessions chewing up a huge amount of RAMI looked again and of course the concatenation should be:
c1 := c1 || id || ' ' c2 := c2 || name || ' ' c3 := c3 || value || ' '
Yechiel Adar
Mehish
You can try concatenation.
Pseudo code:
c1 := null c2 := null c3 := null
c1 := id || ' ' c2 := name || ' ' c3 := vale || ' '
Yechiel Adar
Mehish
I am looking for a way to display rows as columns.
For example:
Id name value
1 a 5
1 b 10
2 a 15
2 b 20
I need it as:
name 1 2
a 5 15
b 10 20
Thank you in advance
Sergei.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: adar76_at_inter.net.il
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 12 2002 - 08:54:02 CST