The return value of any function is the result of the last expression in that clause (in our examples there is only one line).
任何函数的返回值都是子句(在我们的示例中只有一行)中最后一个表达式的结果。
This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。
Only 72% of contracts contained this clause in 2007; 95% of them did in 2009.
2007年只有72%的合同包含这一条款,而在2009年有95%的合同包含了这一条款。
When the BULK COLLECT clause is included, the statement can return multiple rows; the variable in the INTO clause must be an array, and each row is stored in an array element.
在包括BULKCOLLECT子句后,该语句可返回多行;INTO 子句中的变量必须是阵列,且每一行存储在一个阵列元素中。
In addition, the return clause in this query contains conditional logic to determine if an E-mail element is present in a given customer's record.
此外,这个查询中的return子句包含一个条件逻辑,用于判断给定客户的记录中是否存在e- mail元素。
In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the Resolution clause can specify the minimum number of rows to sample for column distributions.
在MEDIUM模式的显式的UPDATESTATISTICS操作中,resolution子句中新的SAMPLINGSIZE选项可以指定列分布进行抽样的最少行数。
In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the resolution clause specifies the minimum number of rows to sample for column distributions.
在使用MEDIUM模式的显式的UPDATESTATISTICS操作中,可以在resolution子句中使用新的SAMPLINGSIZE选项为列分布抽样指定最小行数。
If you use XML predicates in the XMLQUERY function in the select clause of an SQL statement, these predicates do not eliminate any rows from the result set and therefore cannot use an index.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词,则这些谓词不会从结果集中排除任何行,因此不能使用索引。
The penalty clause entitled the plaintiff, in the event of default in payment, to extract a pound of flesh nearest the defendant's heart.
合同的惩罚条款,授权原告在发生履行迟延(default)的情况下,从被告心脏附近割下一磅肉来。
The scope of a persistence unit in terms of its persistent entities is enumerated in the clause of a META-INF/persistence.xml file.
持久化单元作用域的持久化实体在META-INF/persistence.xml文件的子句中枚举。
The CREATE PROCEDURE statement provides special syntax for Oracle routines in packages, a three-part name in the SOURCE clause where the middle part identifies the package.
CREATEprocedure语句为包中的Oracle例程提供了特殊语法,即source子句中分三部分的名称,其中中间的部分标识包。
The extent of insurance is stipulated in the basic policy form and in the various risk clause。
保险的范围写在基本保险单和各种险别的条款里。
The expression used in the if statement (and in the elif clause and the while loop discussed later in this article) can be as complex as necessary.
if语句(以及本文后面讨论的elif子句和while循环)中的表达式可以很复杂。
Congress is arguing about a clause in the $800 billion-plus stimulus package that in its most extreme form would press for the use of American materials in public works.
美国国会正在就8000亿美元的一揽子经济刺激法案中的一项条款进行激烈辩论。该条款极其极端的要求在公共工程建设中必须使用美国生产的物资材料。
The unchanged fields are not used in the WHERE clause, since these fields are not updated in the first place.
没有修改的域未用在WHERE 子句中,这是因为这些域都不是在首先进行更新的。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
对于目标表中匹配的行,将依据更新或者删除子句规范来进行更新或者删除,如图2所示。
In addition, our sample query qualifies the rows of interest by specifying relational and XML predicates in the WHERE clause.
此外,我们的样例查询通过在where子句中指定关系谓词和xml谓词,限定了所关注的行。
If all the columns in the clause appear in the required sequence with a single index, the database server USES the index to read the rows in the ordered sequence, thus avoiding a sort.
如果该子句中所有的列都是以用单个索引要求的顺序出现的,那么数据库服务器就使用索引来按顺序读取行,因而避免了排序。
You can use the in clause to create an index in the same table space where user data resides, or in a different table space.
您可以使用in子句在用户数据所在的表空间上创建一个索引,或者在其他表空间上创建索引。
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子句,该子句只能与分级查询子句组合使用,并且将按预先定义的顺序返回同级查询结果。
The parameter object will be used to set input values in an UPDATE statement, or WHERE clause values in a query (etc.).
这个参数对象将用于设置update语句中的输入值,或者用于设置某一查询中的where子句的值(等等)。
The row order in the query elements table in which columns are defined determines their left to right sequence within the order BY clause, which in turn determines their sorting priority.
定义了列的查询元素表中的行顺序决定了它们在ORDERBY子句中从左到右的顺序,这又确定了它们的排序优先级。
In addition, AS correlation specifications in the FROM clause can declare temporary names for columns within the query.
此外,from子句中的AS相关性规范可以为查询中的列声明临时名称。
This function cannot appear in a DELETE statement's WHERE clause. It is only allowed in queries.
这个函数不能出现在delete语句的where子句中,而只能出现在查询中。
The query finds statements in the graph for which all of the triples in the WHERE clause hold.
查询在具有WHERE子句中的所有三元组的图形中查找语句。
When you use transform expressions in SQL update statements, you rarely have a filtering predicate in the COPY clause but rather in the SQL WHERE clause.
在SQL更新语句中使用转换表达式时,很少在COPY子句中使用筛选谓词,通常是在 SQL WHERE 子句中进行筛选。
The clauses of the query - such as its selection terms, the selection predicate in a WHERE clause, and ordering terms in an order BY clause - can all be mutated.
可以改变查询的子句,比如它的选择条件、WHERE子句中的选择谓词和ORDERBY子句中的排序条件。
So where the original personality theory said, same personality, that's good enough for being the same person, the new version throws in a no-competitors clause, throws in a no branching clause.
所以原人格理论说,相同人格,足以使之成为相同的人,新版人格理论添加了一个无竞争者条件,添加了一个无分支条件。
Like in a regular ORDER BY clause multiple columns can be specified in either ascending or descending sequence.
类似于在常规的ORDERby子句中,可以按升序或降序指定多个列。
The results are saved in the data structure that is specified in the INTO clause.
结果保存在into子句中指定的数据结构中。
应用推荐