Describes how to implement a function that returns table values.
介绍如何实现返回表值的函数。
DM_GETCLUSTERS that returns a table of the clusters in the model together with a short text description about the field distribution in this cluster.
该函数返回一个表,其中包含模型中的集群,以及关于这个集群中字段分布的简短文本描述。
In the next example, the result handler processes a result set and returns an HTML page, displaying the result set contents as a table.
在接下来的例子中,结果集处理程序处理一个结果集,并返回一个html页面,这个页面以表的形式显示结果集的内容。
Another query against the summary table returns no data as well.
再次查询总结表,仍然没有返回任何数据。
Not unexpectedly, a query against the summary table at this point returns no data.
不出所料,此时对总结表的查询没有返回任何数据。
GET_DBM_CONFIG table function Returns database manager configuration information in a table with two rows and a column for each parameter.
get_dbm_config表函数在一个有两行记录的表中返回数据库管理器的配置信息,每列代表一个参数。
Another query against the summary table returns no data, but after the REFRESH table statement executes this time, the query runs successfully.
再次查询总结表,又是没有返回数据,但是当执行了REFRESHtable语句之后,查询得以成功运行。
Normally this method returns all the records from the table.
通常该方法将返回表中的全部记录。
First, let's create a simple stored procedure SP_GET_LOC that returns the location for a given department from the table ORG (step 1).
首先,创建一个简单的存储过程SP_GET _ LOC,它从表org中返回某个给定部门的位置(步骤1)。
A query against this MQT right after it was created, but before the REFRESH TABLE statement was issued, returns an error.
当这个mqt刚创建且还没有发出REFRESHtable语句的时候,对它的查询将返回一个错误。
For this example, in which the database query only returns the rows of a single table, you might just write a small PHP function to wrap each column in an XML tag.
在本例中,数据库查询只返回单个表的行,您也许要编写一个php小函数对XML标记中的每一列进行打包。
It returns the following result set which has as many rows as there are rows in the table.
它返回下面这样的结果集,其中的行数与表中的行数一样多。
Normally, RFC_READ_TABLE returns a table with all the columns that you want to fetch printed to a string.
通常 RFC_READ_TABLE返回一个表,包含所有希望提取的列(作为字符串给出)。
The statement returns the number of bytes for each table entry that are saved by using the value compression row format.
该语句返回使用值压缩行格式为每个表条目节省的字节数。
For example, if used in a SELECT clause, it returns the partition number for each row of the table that was used to form the result of the SELECT statement.
例如,如果用在一个select子句中,那么该函数将返回表中组成select语句结果的每一行的分区号。
The YQL service then looks up the table definition, performs the query, and returns the results.
然后,YQL服务会查找表定义,执行查询并返回结果。
The cursor returns the content of the RETAIL_RULES table containing the association rules.
此指针返回包含有关联规则的 RETAIL_RULES表的内容。
Creating a table function that returns multiple values isn't much more difficult.
创建返回多个值的表函数也不太困难。
First, the NEW_OL _local table function really returns only one row at a time.
首先,NEW_OL _ LOCAL表函数实际上一次只返回一行。
It allows for a query that returns formatted XML, based on a regular table (in our case, with our Census data and schema).
可以使用这个特性查询一个常规表并返回经过格式化的XML(在这里,使用人口普查数据和模式)。
However, this query returns only one XML document from the sample table.
然而,这个查询只返回示例表中的一个XML文档。
Now, to get various portions of the data, I create a stats.php page that, given a start and end index, returns an HTML table with just that portion of the data.
现在,为了获得数据的各个部分,我创建了一个stats.php页面,该页面提供了一个开始和结束索引,返回一个只包含该部分数据的HTML表格。
The REFRESH TABLE statement returns a warning, a reminder that the "integrity of non-incremental data remains unverified."
REFRESHtable语句返回一条警告,提示说“integrityof non - incrementaldata remains unverified ”。
It returns four records from the EMPLOYEE table.
该查询从employee表返回四条记录。
Lock modes and lock object types are defined in the sqlmon.h include file, which will help you to decipher the numerical equivalents that the table function returns.
锁模式和锁对象类型都定义在sqlmon . h包含文件中,该文件将有助于破解表函数返回的数值当量(numerical equivalent)。
This method returns an entity bean for the cart table row with the given CartId.
该方法返回一个用于购物车表的列的实体bean,这个实体bean有一个给定的CartId。
If the fetch function returns TRUE, the catalog id value is defined in the catalog table.
如果fetch函数返回TRUE,则catalog表中已经定义了这个catalogid值。
And the get method returns the current contents of the articles table for the given feed.
get方法为给定提要返回文章表的当前内容。
Get-the get method returns a single row from the table given an integer ID.
get—如果被给予一个整数ID, get方法将返回表中的一行。
The add method just adds the to-do item to the table, then returns new contents for the results tag.
add方法把to - do项添加到表中,然后为得到的标记返回新的内容。
应用推荐