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运算符添加到分级查询子句的CONNECTBY部分。
A pseudo column is an identifier with a predefined name that holds information about the hierarchical query and that can be used like any column in a table.
伪列是具有预先定义的名称的标识符,其中包含关于分级查询的信息;它的用途类似于表中的任何列。
The following example shows a SELECT statement with a hierarchical query clause to return all direct subordinates for the manager Meier (employee number 101).
下列示例显示使用一个SELECT语句和一个分级查询子句来返回Meier经理(雇员编号为 101)的所有直接下属。
Adding an ORDER siblings BY clause which is only allowed in composition with the hierarchical query clause and will return the siblings in the predefined sequence.
添加一个ORDERSIBLINGSBY子句,该子句只能与分级查询子句组合使用,并且将按预先定义的顺序返回同级查询结果。
It offers many new features for application developers, hierarchical data structure support, and improved query capabilities across multiple instances of the database.
它提供了很多面向应用程序开发人员的新特性、分层数据结构支持和改进的跨多个数据库实例的查询能力。
Because this information is a few nodes down in the tree, dot notation is used to indicate the exact hierarchical position of the required nodes to the query parser.
因为此信息是树下的几个节点,所以点符号用于说明针对查询解析器的所需节点的确切层次位置。
The real distinction between path components and query parameters is that between hierarchical versus unordered arguments.
路径成分与查询参数之间真正的差异是,前者是层次化的,而后者是无次序的。
In order to execute this report with no error, Dynamic Query Mode requires that levels from the same hierarchy be adjacent in the same hierarchical order.
为了正确执行这个报告,DynamicQueryMode要求来自相同层次的级别在相同的层级顺序中相邻。
You can populate an XML tree with hierarchical data, and then query it, transform it, and if necessary, serialize it.
您可以使用层次结构数据填充XML树,然后对它进行查询、转换和序列化(如有必要)。
You can populate an XML tree with hierarchical data, and then query it, transform it, and if necessary, serialize it.
您可以使用层次结构数据填充XML树,然后对它进行查询、转换和序列化(如有必要)。
应用推荐