Re: Need help Reformatting output

Thu, 12 Dec 2002 07:59:23 -0800

Title: RE: Active sessions chewing up a huge amount of RAM
I looked again and of course the concatenation should be:
 
c1 := c1 || id || ' '
c2 := c2 || name || ' '
c3 := c3 || value || ' '
 
Yechiel Adar
Mehish
----- Original Message -----
Sent: Thursday, December 12, 2002 10:38 AM
Subject: Re: Need help Reformatting output

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