但是首先我们还是来讨论伪列。
在分级查询中,提供了几个伪列。
For hierarchical queries several pseudo columns are provided.
在下列示例中,在选择列表中指定伪列LEVEL。
In the following example, the pseudo column LEVEL is specified on the select list.
下面的示例中将显示使用level伪列的另一种方法。
Another way to use the LEVEL pseudo column is shown in the following example.
还可以使用伪列值按照宽度优先顺序对查询结果进行排序。
The pseudo column value is also used to sort the query results in breadth-first sequence.
这个伪列只是当一个给定行在递归中是叶子的时候返回1。
All this pseudo column does is to return 1 if a given row is a leaf in recursion.
可在字符串中使用伪列LEVEL,使分层结构变得可视。
The pseudo column LEVEL is used in a string to make the hierarchy visible.
LEVEL—伪列LEVEL返回一个整数值,表示所生成行的分层结构中的递归步骤。
LEVEL - the pseudo column LEVEL returns an integer value that represents the recursive step in the hierarchy at which the row was produced.
可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
伪列是具有预先定义的名称的标识符,其中包含关于分级查询的信息;它的用途类似于表中的任何列。
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.
在讨论伪列和更复杂的例子之前,我想简要地解释一下Oracle中递归的WHERE谓词应该放在哪里。
Before moving on to pseudo columns and more complex examples, I want to briefly explain where the where predicate of an Oracle recursion needs to be placed.
除非oracle引入了我不知道的其他伪列或关键字,否则Oracle所有的递归特性现在都被映射到DB 2UDB forLinux、UNIX和Windows。
Unless Oracle has introduced yet another pseudo column or keywords that I'm not aware of, all of Oracle's recursive features have now been mapped to DB2 UDB for Linux, UNIX, and Windows.
采用关于网格理论的方法,对线性同余序列及向量列在其作为伪随机序列模拟均匀分布时的偏差加以讨论并给出估计。
This article deals with error bounds for linear congruential sequences and vectors which are used as pseudorandom Numbers and vectors of uniform distribution.
采用关于网格理论的方法,对线性同余序列及向量列在其作为伪随机序列模拟均匀分布时的偏差加以讨论并给出估计。
This article deals with error bounds for linear congruential sequences and vectors which are used as pseudorandom Numbers and vectors of uniform distribution.
应用推荐