How to get same type of data in same line in PL/SQL.?

Question

Suppose we have a table of two column like:

'A', '12'
'B', '34'
'B', '45'
'B', '67'
'C', '89'
'C', '98'
'D', '43'

Now I want a output shows like:

'A', '12'
'B','34','45', '67'
'C', '89', '98'
'D', '43'

So, what query I have to write for that...??

Abhimanyu K Vatsa · Answer

Hello Manish As u r wishing to get output please reply something Is there any logical relation between 'A' and 12 'B' and 344567 'C' and 89 98 'D' and 43 Why not something in different form like 'A' and 3445 'B' and 89 'C' and 98 'D' and 67 I mean there must be some logic that you are wishing to apply to get your output? Please reply.