Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sql query

sql query

From: sudhakar Reddy <sudhakarcv_at_rediffmail.com>
Date: Sun, 30 Mar 2003 22:08:37 -0800
Message-ID: <F001.00575FED.20030330220837@fatcity.com>


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&&wn

--

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). Received on Mon Mar 31 2003 - 00:08:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US