DELETE FROM SFL_YWZYFL WHERE YWZYFL_ID IN (SELECT YWZYFL_ID FROM SFL_YWZYFL START WITH YWZYFL_ID IN(:ids) CONNECT BY PRIOR YWZYFL_ID=SFL_YWZYFL_ID)
不要沉啊!
嚣张恒少的博客– 功能:替代oracle start with connect by语法,递归查询 – 参数说明 : startid参数:start with 后面的字段值 – v_start_with参数:start with id:s(包含这条数据), start with parent_id:p(不包含这条数据)...