RE: Need help Reformatting output

[Steve McClure]

Title: RE: Active sessions chewing up a huge amount of RAM

What tool are you using to produce this?  sqlplus?  If you can use plsql, my first thought would be to build a plsql table that would be laid out in the format you want the data presented in. load the array in one pass, and then loop through it to display the output via utl_file or somesuch.  Actually if you are familiar with perl you could use a similar algorithm, and the resulting code would likely be cleaner.   Steve McClure -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sergei Sent: Wednesday, December 11, 2002 6:59 PM To: Multiple recipients of list ORACLE-L 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.