Select Code to Download

create table organization(
orgid number not null primary key,
...
insert into orglevels values (1,'Sector');
insert into orglevels values (2,'Department');
insert into orglevels values (3,'Division');

select orgid,orgname,orgparent,level,l.levelname from organization o s
+tart with orgparent is null connect by prior orgid=orgparent
left join orglevels l on l.levelid=level