Need tp Print Parent Child Records in Specific Format
===

I am looking for some help in writing a sql query to print Parent-Child records in this structure -

First Parent Record columns
First child record of above parent
Second child record of above parent
Third child record of above parent

Second Parent Record
First child of above parent
Second child of above parent

Third Parent Record
First Child of above Parent.


Set of columns can be defined as generic varchar2 so it can have all types of data.

Can anyone help in writing such query using join/group by or some analytical functions ?

Thanks in advance !!

Best Regards
Ashish
 