SQL & PL/SQL

Hi everyone!

I have a requirement to put child records into columns.

With data something like this:

Table name: parents

Column 1: parent_id

Column 2: first_name

column 3: last_name

Table name: children

column 1: child_id

column 2: parent_id

column 3: first_name

column 4: last_name

Table 1 data:

1  john smith

2  grizzly adams

Table 2 data:

3  1  jack smith

4  1  jill smith

5  2  grizzJr adams

6 2  goldielox adams

7 2  grettle adams

Looking for data output to be like this:

How do I dynamically move the children into columns to the right of the parent table?

Thanks so much!!!

Tim