Oracle-L: RE: sql query

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 31 Mar 2003 06:48:42 -0800
Message-ID: <F001.0057620E.20030331064842@fatcity.com>

Reddy

There are a variety of techniques to accomplish this, and it is difficult to determine which will work best in your situation. Here is a link to a classic article on this topic by the great Jonathan Gennick who participates in this list from time to time.
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, March 31, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L

hi,

i have a table with indent number and quantity with 10 rows

ex ind_no             qty
     1                  10
     1                  12
     1                  30
     1                  15
     1                  30

     2                  12
     2                  30
     2                  15
     2                  30
     2                  25

     2

I have to dispay it as rows
like

   1      10   12   30   15   30
   2      12   30   15   30   25

please help,

regds,
Sudhakar

Odomos - the only mosquito protection outside 4 walls - Click here to know more!
http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&w n

--

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

Author: sudhakar Reddy
INET: sudhakarcv_at_rediffmail.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).
--

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

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------