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

From: Don Dealy II <dondealy_at_teleport.com>
Date: Sun, 24 Jun 2001 20:54:50 -0700
Message-ID: <F001.00335BF0.20010624204019@fatcity.com>

Sample Table
 

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

Sample Data
 

<FONT face="Courier New"
size=2>DocId    DateVal        TextVal        NumVal <FONT face="Courier New"
size=2>12       01/15/2000    

<FONT face="Courier New"

size=2>12                      Sally 

Smith   
<FONT face="Courier New"

size=2>5                       Bob 

Brown
<FONT face="Courier New"

size=2>5                                      48702               

5       
07/22/2001
<FONT face="Courier New"

size=2>4                                      

152
 
 
 

Desired result after SELECT...
 

<FONT face="Courier New"
size=2>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:  <A
href="mailto:dondealy_at_teleport.com">dondealy_at_teleport.com
 
 
Received on Sun Jun 24 2001 - 22:54:50 CDT