Recursive records oracle

Question

I'm currently trying to create a report using SQL Developer.

I have these 2 tables:

PERSONS (IDPerson, NamePerson) PENALTIES (IDPenalty, DatePenalty, Description, IDPerson)

The tables are polulated.

How could I create a table like

THIS

using recursive queries in SQL? or it's there any other solution? Thank you in advance.

Agreed - an almost exact duplicate. The other question didn't need the join to retrieve the "name" associated with the id, but that is a separate and different kind of question (vs. the list aggregation question which is the main topic). — user5683823
– user5683823, Commented Oct 10, 2016 at 12:04

score 2 · Accepted Answer · 2016-10-10 12:03:10Z

2

select   p.nameperson as name, p.idperson as id,
         listagg(to_date(x.datepenalty, 'dd/mm/yyyy') || ' - ' || x.description, '; ')
                                      within group (order by x.datepenalty) as penalties
from     persons p left outer join penalties x
                   on p.idperson = x.idperson
group by p.idperson;

(Not tested - you didn't provide test data.)

edited Oct 10, 2016 at 12:03

answered Oct 10, 2016 at 11:59

user5683823

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Recursive records oracle

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related