plsql - Dont know how to solve a maybe infinitfe loop (Tree) -

i have problem. have element , list of elements, connected first 1 in way. want check, elements of list children of first. save result in array. pick first child , children. save , on , on , on. problem is, dont know exact number of relations. have many many loops , searches. need program every single loop , array (to save to) or there better way?

edit: iam talking db tables. have 2 tables. want check children (data in table2) every element in table1. start loop in table1. elements in table 1 , table2 connected coordinates xy. iam searching elements in table2 table1_element1.xy == table2.xy. result there n children. want save them , start children new loop find every child children based on coordinates. save new result on , on. more clear?

thank you.

this problem can solved of recursion.

in case termination condition when node don't have relation in list or when reach end of list storing children.

thanks