Oracle-L: RE: Need help Reformatting output

From: Steve McClure <smcclure_at_usscript.com>
Date: Fri, 13 Dec 2002 10:03:48 -0800
Message-ID: <F001.00519553.20021213100348@fatcity.com>

RE: Active sessions chewing up a huge amount of RAMWhat 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: root_at_fatcity.com [mailto:root_at_fatcity.com]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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve McClure
INET: smcclure_at_usscript.com

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 Fri Dec 13 2002 - 12:03:48 CST