Multiple results in a single record - Oracle

Question

I have the following situation: I have a select where I return that the patient TEST passed the clinic ABC, and performed procedure 01 and 02, however in the result of query he returns to me like this bold text:

Patient | Clinical | Procedure |

Test | ABC | 01 |
Test | ABC | 02 |

But I needed the following result:

Patient | Clinical | Procedure |

Test | ABC | 01 - 02 |

I’d like some help.

Answer 1

function listgg solves

select paciente
     , clinica
     , listagg(procedimento, ' - ') within group (order by procedimento)   procedimento
from tabela
group by paciente, clinica

https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030