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!

MERGE THE RECODS

user549774Oct 9 2007 — edited Oct 9 2007

My table contains below records, i want to display the unique records like below output.

INPUT
-----
PNRNo TicketNo PNRName Desc
---------------------------------------------------------------------------------
P1 1 Pavithra asdfasfafs
P1 2 Pavithra jjjjjjjjjjjjjjj
P1 3 Pavithra hhhhhhhhhhh
S1 1 Sangeetha sdfdfsdfsdf
S1 2 Sangeetha sdfdfsdfsdfsdfs
S1 3 Sangeetha sdfdfsdfsdfsdfsd
A1 1 Aruna sdfsdfsddd

I need to merger the ticket PNRNo vice. The above table will come look like BELOW

OUTPUT
----------
PNRNo TicketNo PNRName Desc
---------------------------------------------------------------------------------
P1 1,2,3 Pavithra asdfasfafs
S1 1,2,3 Sangeetha sdfdfsdfsdf
A1 1 Aruna sdfsdfsddd

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2007

Added on Oct 9 2007

2 comments

158 views