Query to retrieve parent-child aggregate records



Please help me with a query in oracle database for the given scenario , this is very urgent any help is appreciated

For a given product with a codevalue 123 with 2 ingredients AA with weight 10gm and BB with weight 15gm , i need concatination value of codevalue+ingredient1+weight1+ingredient2+weight2 for a given product i.e 123AA10GMBB15GM.

so the final output should be codevalue+ingredient1+weight1+ingredient2+weight2+ingre3+weight3+.....

thanks