问题
这是一个树结构,查询教师“胡明星”的所有主管及姓名:(无主管的教师也需要显示),显示(教师编号、教师名称、主管编号、主管名称)
解决1
SELECT ht1.teacher_no,
ht1.teacher_name,
ht1.manager_no,
ht2.teacher_name manager_name
FROM hand_teacher ht1,
hand_teacher ht2
WHERE ht1.manager_no = ht2.teacher_no(+)
START WITH ht1.teacher_name = '胡明星'
CONNECT BY PRIOR ht1.manager_no = ht1.teacher_no;
解决2
select *
from HAND_TEACHER
start with teacher_name='胡明星'
connect by teacher_no=prior manager_no