An Oracle query to the parent node from a child node ____oracle

Today, a person in the department asked me how to trace from a child node record to a parent node in Oracle. For example, there is a table:

GUID Parentguid

1 0

2 1

3 1

4 2

5 2

6 5

7 5

8 7

We can detect all the child nodes under the GUID from the GUID 1 according to the parentguid relationship.

Now to find out its parent node, the 7->5->2->1 relationship, from a child node such as GUID 7.

In fact, this is a very funny question, if you can detect child nodes from the parent node, then, in turn, the GUID of the child node as the parent node of the Parentguid

The child node becomes the parent node. So

Select GUID from test start and GUID =7 connect by prior Parentguid = GUID

That can detect the relationship between 7->5->2->1