DELETE FROM AMC_DEPT WHERE ID IN (SELECT ID FROM AMC_DEPT start with ID=4 connect by prior ID=PID)
注意:id为菜单主键,pid为子菜单中父菜单主键。
oracle 删除级联树形结构数据
最新推荐文章于 2022-10-20 16:02:36 发布
DELETE FROM AMC_DEPT WHERE ID IN (SELECT ID FROM AMC_DEPT start with ID=4 connect by prior ID=PID)
注意:id为菜单主键,pid为子菜单中父菜单主键。