Assuming your Oracle version can support it, you can use a
user-defined aggregate function. See this previous Google post:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&frame=right&th=1051b0ddcfbe2f5&seekm=42fc55dc.0408240620.648e858a%40posting.google.com#link4
arif.faruqi_at_gmail.com (Arif) wrote in message news:<cae3fa27.0409290822.7e453274_at_posting.google.com>...
> Hi Folks,
>
> This is the query I am trying to write. I have a table which can have
> multiple rows for one column say
> Jobid but different values for another column say ticket Id.
>
> Table looks like this.
>
> Job Id Ticket Id
> 1 100
> 1 99
> 2 20
> 2 40
> 2 60
>
> I want to write a query against this table so that I get only one row
> back
> for the job id and the ticket ids for that jobid are concatenated
> together
> like below.
>
> JobId Ticket Id
> 1 100,99
> 2 20,40,60
>
>
> Is this possible through SQL or I have to write some Pl/Sql. can you
> share some code examples
>
> Thanks
Received on Wed Sep 29 2004 - 21:40:59 CDT
