oracle 递归

select level level_num,b.*  

from fnd_flex_value_children_v b  

 where b.flex_value_set_id= 1014868  

 and b.parent_flex_value <>'T'  

 connect by prior b.parent_flex_value = b.flex_value  

 start with b.flex_value ='100110210';