有一個部門表(T_Department):
T_Department:
ID :varchar2(25)
Name:varchar2(100)
SuperiorID:varchar2(25)
SuperiorName:varchar2(100)
Remark:varchar2(1000)
根據一個部門的ID,獲取該部門下所有的子部門,例如部門的ID為“D”:
select * from T_Department
Start with ID='D'
Connect by prior ID=SuperiorID