oracle 删除级联树形结构数据

DELETE FROM AMC_DEPT WHERE ID IN (SELECT ID FROM AMC_DEPT start with ID=4 connect by prior ID=PID)

注意：id为菜单主键，pid为子菜单中父菜单主键。