Additionally, for each row, we will return a valid XML document containing a root element only.
另外,对于每一行,返回一个有效的XML文档,其中只包含一个根元素。
Thus, the federated queries which benefit the most from asynchrony are those whose remote queries are complex and and for which it is time consuming to return the first row.
因此,能从异步中获得最多好处的联邦查询是那些其远程查询比较复杂,在返回第一行数据之前需要花费较多时间的查询。
All this pseudo column does is to return 1 if a given row is a leaf in recursion.
这个伪列只是当一个给定行在递归中是叶子的时候返回1。
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 子句中的变量必须是阵列,且每一行存储在一个阵列元素中。
The UNION operator consumes the data a row at a time from the SHIP buffer and flows the row upwards to the application through the RETURN operator.
UNION操作符每次使用SHIP缓冲区中的一行数据,并将这行数据通过RETURN 操作符上传到应用程序。
This would return 1 row, and the estimate is 2.176.
该查询将返回1行,而估计值是2.176。
Listing 3. Update new row pointer and return test data.
列表3.更新新的行指针,并返回测试数据。
Listing 1. Get file row pointer and initialize return variable.
列表1.获得文件行指针并初始化返回变量。
This cell object, in turn, exposes methods to return the row number, column number, and value of the corresponding cell.
这个cell对象反过来又公开一些方法来返回行号、列号和对应单元格的值。
The SELECT statement allows us to return one row per region identified by the name column.
这个select语句对于每个地区返回一行,地区名由name列表示。
Create a custom grid select editor to return the options for a selected row.
创建一个定制的网格编辑器来返回针对所选行的选项。
So, assuming there's at least one row in the Users table, this SQL will always return a nonzero count of records.
因此,假定users表中至少存在一行,此SQL将始终返回非零的记录计数。
Basically, the purpose of this indexer is to return a point corresponding to a given row and column on the drawing surface. Follow these steps.
本质上,该索引器的目的是返回一个与绘制面上已知的行和列相对应的点。
At run-time, your RowHandler decides which one is the appropriate object to return for the current result set row.
在运行时,RowHandler决定对于当前的结果集行返回哪种对象。
Minimally, you can override the formatter for the grid select editor to return option information for the selected row.
最基本的一种方式是覆盖此网格select编辑器的格式化程序来返回针对所选行的选项信息。
The SELECT INTO must return a single row or it fails.
SELECTINTO必须返回单个行,否则就会失败。
Regular SELECT INTO statements can return only one row.
常规的SELECTINTO 语句只返回一行。
The remote queries are complex, time consuming and take some time to return the first row
远程查询比较复杂,需要消耗较多时间,必须在执行较长时间之后才能返回第一行数据。
For example, if a result row is larger than 32k bytes and the setting for rqrioblk is also at 32k (the default), each row will take two blocks to return.
例如,如果返回的行大于32k字节,并且rqrioblk也设置在32 k字节(默认情况),那么每一行将分两个块返回。
The return type of “Table” should be used if you want to return more than one row or value.
如果要返回多个行或值,则应该使用返回类型“Table”。
In addition, if the remote operations take approximately the same amount of time to return the first row, then the benefit achieved in enabling asynchrony is maximized.
此外,如果远程查询都是执行大约相同一段时间之后返回第一行数据,那么异步带来的好处就可以实现最大化。
There is no need to find them all, and indeed, it would be harmful, because we want to return each row only once.
这里没有必要返回所有子行,实际上这样做反而有害,因为我们不想返回重复的行。
Each return row call adds a new row into the returned result set where column values are the current values of the result set column names.
每个RETURN ROW调用向返回的结果集增添一个新行,该结果集中的列值为结果集列名的当前值。
The true value for the second configuration setting requires your JDBC driver to return the correct row counts from executeBatch().
第二个配置设为true,这要求JDBC驱动在executeBatch()方法中返回正确的行数。
Subqueries are generally used to return a single row as an atomic value although they may be used to compare values against multiple rows with the IN keyword.
子查询一般用来返回一个单独的行作为原子值,然而还可以用来比较多行的值,利用IN关键字。
The variable association dialog is launched by clicking the value column of the condition row, and selecting Use a variable to return the value in the drop-down box.
通过单击条件行的value列,并在下拉框中选择useavariabletoreturnthe value,可以打开变量关联对话框。
Finally, note how the single row VALUES clause is used in the return statement to return the end result as a single-row table.
最后,注意在return语句中使用了单行的values子句,以便将最后的结果以单行的表的形式返回。
每一行返回一个结果。
Since it appears in more than one row in our dataset, the query should return that.
因为它出现在超过一行在我们的数据集,该查询将返回。
For example, the query might return the first column of the first row of the returned data.
例如,查询可能返回所返回数据的第一行的第一列。
应用推荐