Please master help! !! !! Problems removing tree structure

majunbuzai

Now there is a table that stores the file directory ID, which indicates the parent-child relationship. Now give a node and ask to delete all the nodes under it, master help! !! !!
E.g
                             1
                         twenty three
                        4 5 | 6
                       7 8 9 10
This structure, 1 under 2, 3
2 is 4, 5
4 is 7, 8
.. .
Requires input 2
Delete 4, 5, 7, 8 under 2?
There are best examples, thank you!

sanshuimei

What is the structure of the table? What is the data in the table?

Give an example

majunbuzai

Table structure p s
       1 2
       1 3
       twenty four
       2 5
       4 7
       4 8
In this way, is it okay to correspond to the above?sanshuimei

cqj8272

delete from test where rowid in (select rowid from test
start with id=1
connect by id = prior nextid)