Re: How to return Multi-row query into a single row?

[DBarbour]

Don,

In you code, add the line

          GROUP BY DocID

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


                                                                                       
                       
                    "Don Dealy                                                         
                       
                    II"                  To:     Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
                    <dondealy@tel        cc:                                           
                       
                    eport.com>           Subject:     How to return Multi-row query 
into a single row?        
                    Sent by:                                                           
                       
                    root@fatcity.                                                      
                       
                    com                                                                
                       
                                                                                       
                       
                                                                                       
                       
                    06/24/2001                                                         
                       
                    11:40 PM                                                           
                       
                    Please                                                             
                       
                    respond to                                                         
                       
                    ORACLE-L                                                           
                       
                                                                                       
                       
                                                                                       
                       




Sample Table

DocId     Integer
DateVal   Date
TextVal   Varchar2(40)
NumVal    Number(10,0)


Sample Data

DocId    DateVal        TextVal        NumVal
12       01/15/2000
12                      Sally Smith
5                       Bob Brown
5                                      48702
5        07/22/2001
4                                      152



Desired result after SELECT...

DocId    DateVal        TextVal        NumVal
12       01/15/2000     Sally Smith
5        07/22/2001     Bob Brown      48702
4                                      152


How do I write a query to produce the "single row" result?



Thx - Don

e:  [EMAIL PROTECTED]





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).