start with & connect by

select level div_level, ou_code, div_code, div_code || ' ' || div_name div_name
from su_division
where ou_code =:parameter.ou_code
start with div_parent is null
connect by prior div_code = div_parent
and prior ou_code =:parameter.ou_code