The hierarchical query clause consists of two portions.
分级查询子句由两部分组成。
The hierarchical query clause is easier to understand than the RCTE syntax.
与 RCTE 语法相比,分级查询子句较更容易理解。
To get all subordinates over all levels, the PRIOR operator must be added to the CONNECT BY part of the hierarchical query clause.
要获取所有级别上的所有下属,必须将PRIOR运算符添加到分级查询子句的CONNECT BY部分。
应用推荐