Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql group by query and concatenation

7688438Jan 18 2010 — edited Jan 18 2010
Hi folks,

I have question.I need to concatenate the columns like this.

i/p

i_txt txt

1000 abc
1000 def

1001 things
1001 to
1001 do


1002 is
1002 it
1002 possible

O/P should be like this

i_txt txt
1000 abcdef
1001 things to do
1002 is it possible


Thanks in advance
Raj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2010
Added on Jan 18 2010
3 comments
749 views