Combine Rows?

[vb89]

I'm trying to combine two rows under one column.

using: oracle 10g

Here is my code

select 
    cr.report_id as report_id,
    cr.report_name as report_name,
    ei.info as info
from SPSS.WEB_CLIENT_REPORTS_NFL CR,  spss.web_report_extra_info_nfl EI
where cr.report_id = ei.report_id

current output

report_id /  report_name    / info
11111        player scored      When a individual croses     
11111        player scored      the opponents end zone

what i want the output to be

report_id /  report_name    / info
11111        player scored      When a individual croses the opponents end zone

Thanks

 

[Ascalonian]

I believe this is an aggregate function? Or am I totally off my rocker?

 

[LKBrwnDBA]

Yes, there is an aggregate: WS_CONCAT()


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

Also check: sys_connect_by_path().


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[vb89]

Is there any other way of doing what i stated above?

 

[SantaMufasa]

VB89,

There are several ways to do what you want. Two of the methods appear in thread1177-1511701.

[ul][li]Method 1: My post at 7 Nov 08 14:06.[/li]
[li]Method 2: My post at 20 Nov 08 17:09.[/li][/ul]

Simply specify the delimiter as a blank space instead of a comma.

Let us know how either of those work for you.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[jaxtell]

I don't know what ws_concat is, and it doesn't seem to work in the database I'm using. I had to create my own aggregate function to do what you're talking about. You can find some info on that here

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/