Create Table Dept (Departno varcha2 (10), DepartName Varchar2 (20), Topno varchar2 (10));
INSERT INTO Dept Values ('001', 'Board', '0'); Insert Into Dept Values ('002', 'President's Office', '001'); INSERT INTO Dept Values ('003', 'Finance " , '001'); INSERT INTO DEPT VALUES ('004', 'Market Department', '002'); Insert Into Dept Values ('005', 'Public Relation Department', '002'); Insert Into Dept Values 006 ',' sales department ',' 002 '); INSERT INTO Dept Values (' 007 ',' Distribution Office ',' 006 '); INSERT INTO Dept Values (' 008 ',' Business Expansion ", '004' INSERT INTO DEPT VALUES ('009,' Sales ", '007');
Create Table Tempdept (Tempdeptno Char (4), / * Department Number * / TempdeptName VARCHAR2 (20), / * Department Name * / Uppertempdeptno Char (4), / * Superior Department Number * / UppertemPdeptname Varchar2 (20), / * Super Level Department Name * / TempdePTlevel Number (4) / * Level * /);
Select DepartNameFrom DeptConnect by prior departno = Topnostart with topno = '0';
Select A.DepartName Top, B.DepartName Nextfrom Dept A, Dept bwhere a.departno = b.topno;
Select LPAD (departno, level * 2 length (departno), '/') from deptstart with topno = '0'connect by prior departno = topno;
Select Departno, DepartName, Level || '/' || Topnofrom DeptStart with Topno = '0'Connect by prior departno = topno;
Select LPad (departno, level * 2 length (departno), '') from deptstart with topno = '0'connect by prior departno = Topno;
Select LPAD (Departmentno, Level * 3, ')
