做了个树型结构,在删除的时候遇到了问题,删除父节点的时候,把它下面的子节点一起删除,但出现问题:ORA-00933: SQL 命令未正确结束delete from zd_wzfl where
wzflh='1000'
start with sjflh is null
connect by sjflh = prior wzflh
wzflh='1000'
start with sjflh is null
connect by sjflh = prior wzflh
---------- ----------
1
2 1
3 1
4 2
5 2
6 2
7 6已选择7行。demo@HASL>delete from test_prior
2 where rowid in
3 (
4 select rowid from test_prior
5 connect by prior id = pid
6 start with id = 2
7 );已删除5行。demo@HASL>select * from test_prior; ID PID
---------- ----------
1
3 1不太清楚楼主的表结构,存储的是本身,子节点还是本身,父节点?表结构也不清楚?