sql query

[pras]

Hi Guys....

Need to make a solution to fecth data from single SQL query....

Table: tbl_test

Columns | SERVICE | PROTOCOL | DESTINATION
-----------------------------------------------------------
| 10 | T | x
| 10 | T | y
| 10 | T | z

Need to fecth the all above data Group by SERVICE; in single record as follow (last colum values comma seperated):

SERVICE | PROTOCOL | DESTINATION
-------------------------------------------------
10 | T | x, y, z

HOW TO MAKE IT POSSIBLE?

Thanks in advance
pras

[DaPi]

Search here or on "Ask Tom" (http://asktom.oracle.com/pls/ask/f?p=4950:1:) or Google or anywhere for "pivot".