http://qs321.pair.com?node_id=252409


in reply to Deleting a branch from a tree structure

I think you'd be better off using PL/SQL or Oracle's "CONNECT BY" extensions. There's a tutorial here.