Recursive common table expressions (RCTE).
递归通用表表达式(RCTE)。
And populate the T_SHIRT table using two table expressions.
并使用两个表表达式来填充t _ shirt表。
These sub queries are called derived tables or table expressions.
这些子查询被称作派生表或表表达式。
The example in Listing 3 shows the creation of structured XML using common table expressions.
清单3中的示例显示了使用公共表表达式创建结构化的XML。
Notice, in lines 45-46, the XML contents placement from the first two common table expressions.
注意，在第45 - 46行中，XML内容来自于最开始的两个公共表表达式。
Common table expressions (the WITH clause) allow efficient pipelining of data-change-operations.
公共表表达式(with子句)允许数据更新操作的高效管道。
Some relational database management systems (RDBMSs), such as Sybase, do not support table expressions in the FROM clause.
有些关系数据库管理系统(RDBMS)，例如sybase，不支持在from子句中使用表表达式。
Therefore, it might be worthwhile to restructure your spatial query to ensure just a single call to the constructor function using common table expressions.
因此，可能有必要使用公共表表达式重新构造空间查询，以确保只调用一次构造函数。
In this article I provided generic mappings from the Oracle style CONNECT BY recursive query syntax to DB2's standard compliant recursive common table expressions using UNION ALL.
在本文中，我提供了从oracle型CONNECT BY递归查询语法到DB 2中遵从标准的使用UNION ALL的递归公共表表达式的通用映射。
Table 3 shows the needed columns and their corresponding data types and path expressions.
表3显示所需的列和它们相应的数据类型和路径表达式。
As part of the transformation, the optimizer also determines the correct table join order, rewrites expressions, and eliminates any redundancy from the SQL.
作为转换的一部分，优化器还决定正确的表联接顺序，重写表达式，并从SQL中消除任何冗余。
Table 2 shows the DOM expressions of locating elements.
表2展示了定位元素的DOM表达式。
In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
在这两种情况下，考虑在伪事实表的连接表达式中添加额外的逻辑，这会缩小从维度表返回的连接键值的范围。
You can string together the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regular expressions.
您可以连接表1中显示的元素(以及其他操作符)并加以组合使用，从而构建(非常)复杂的正则表达式。
Table 1 shows the Xpath expressions of locating elements.
表1展示了定位元素的Xpath表达式。
It USES XPath expressions to map input table fields to certain positions in the output documents.
它使用XPath表达式将输入表字段映射到输出文档中的某些位置。
A column mapping that is a set of XPath expressions, which find attributes of those model objects, forming the columns of the table.
一个直行映射，即一个XPath表达式的集合，它找出形成表格每列的模型对象的属性。
Convert each of the attributes identified above for di into SQL expressions. Table 5 gives an example using the QUARTER_NAME attribute from the time dimension.
将上面识别出的每个di属性转换为SQL表达式。
XMLTABLE is a SQL table function that returns a table from the evaluation of XQuery expressions on an XML document.
XMLTABLE是一个sql表函数，它对一个XML文档执行XQuery表达式并返回一个表。
You'll learn more about these expressions later. For now, enter an expression that refers to the user ID in the current row of the outer table, as described in the following steps.
稍后您将会学到更多关于这些表达式的信息。
Finally, we join these four Boolean product expressions together by addition, to create a single Boolean expression describing the truth table as a whole.
最后，为了建立一个单一的布尔表达式描述真值表作为一个整体，我们同这四个产品的布尔表达式一起此外。
A describing table composition is to transfer the data presented in a table into literal expressions.
图表作文就是把图表上的数据用文字表达出来。
The following table illustrates the use of expressions in a query.
下表阐释查询中表达式的使用。
The following table illustrates the use of expressions in a query.
下表阐释查询中表达式的使用。
应用推荐