Title: RE: Active sessions chewing up a huge amount of RAM
You can try concatenation.
 
Pseudo code:
c1 := null
c2 := null
c3 := null
open cursor
while not end-of-set
     c1 := id || ' '
     c2 := name || ' '
    c3 := vale || ' '
end-loop
 
Yechiel Adar
Mehish
----- Original Message -----
From: Sergei
Sent: Thursday, December 12, 2002 4:59 AM
Subject: Need help Reformatting output

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.

Reply via email to