标准数据库技术词汇之ISO/IEC 9075-2（7）

字数 4320阅读 856评论 0赞 0

[**前言**](https://www.talkwithtrend.com/Article/264637 "**前言**")
[**ISO/IEC 2382（1）**](https://www.talkwithtrend.com/Article/264639 "**ISO/IEC 2382（1）**")
[**ISO/IEC 2382（2）**](https://www.talkwithtrend.com/Article/264641 "**ISO/IEC 2382（2）**")
[**ISO/IEC 2382（3）**](https://www.talkwithtrend.com/Article/264643 "**ISO/IEC 2382（3）**")
[**ISO/IEC 2382（4）**](https://www.talkwithtrend.com/Article/264667 "**ISO/IEC 2382（4）**")
[**ISO/IEC 2382（5）**](https://www.talkwithtrend.com/Article/264671 "**ISO/IEC 2382（5）**")
[**ISO/IEC 2382（6）**](https://www.talkwithtrend.com/Article/264673 "**ISO/IEC 2382（6）**")
[**ISO/IEC 2382（7）**](https://www.talkwithtrend.com/Article/264679 "**ISO/IEC 2382（7）**")
[**ISO/IEC 2382（8）**](https://www.talkwithtrend.com/Article/264683 "**ISO/IEC 2382（8）**")
[**ISO/IEC 2382（9）**](https://www.talkwithtrend.com/Article/264687 "**ISO/IEC 2382（9）**")
[**ISO/IEC 2382（10）**](https://www.talkwithtrend.com/Article/264689 "**ISO/IEC 2382（10）**")
 [**ISO/IEC 2382（11）**](https://www.talkwithtrend.com/Article/264693 "**ISO/IEC 2382（11）**")
[**ISO/IEC 2382（12）**](https://www.talkwithtrend.com/Article/264697 "**ISO/IEC 2382（12）**")
[**ISO/IEC 2382（13）**](https://www.talkwithtrend.com/Article/264707 "**ISO/IEC 2382（13）**")
[**ISO/IEC 9075-1（1）**](https://www.talkwithtrend.com/Article/264709 "**ISO/IEC 9075-1（1）**")
[**ISO/IEC 9075-1（2）**](https://www.talkwithtrend.com/Article/264713 "**ISO/IEC 9075-1（2）**")
[**ISO/IEC 9075-1（3）**](https://www.talkwithtrend.com/Article/264717 "**ISO/IEC 9075-1（3）**")
 [**ISO/IEC 9075-2（1）**](https://www.talkwithtrend.com/Article/264725 "**ISO/IEC 9075-2（1）**")
[**ISO/IEC 9075-2（2）**](https://www.talkwithtrend.com/Article/264773 "**ISO/IEC 9075-2（2）**")
[**ISO/IEC 9075-2（3）**](https://www.talkwithtrend.com/Article/264777 "**ISO/IEC 9075-2（3）**")
[**ISO/IEC 9075-2（4）**](https://www.talkwithtrend.com/Article/264779 "**ISO/IEC 9075-2（4）**")
[**ISO/IEC 9075-2（5）**](https://www.talkwithtrend.com/Article/264781 "**ISO/IEC 9075-2（5）**")
[**ISO/IEC 9075-2（6）**](https://www.talkwithtrend.com/Article/264787 "**ISO/IEC 9075-2（6）**")

**ISO/IEC 9075-2（7）**

returned result set
result set created during execution of an SQL-invoked procedure and not destroyed when that execution terminates
Note 1 to entry: Such a result set can be accessed by using a cursor other than the one that brought it into existence (a received cursor).
**返回结果集**
在执行SQL调用过程期间创建的结果集，且在该执行终止时不会被销毁
注：可使用 游标访问这样的结果集，不可使用产生该结果集的游标（接收游标）访问。

row pattern
form of regular expressions that specifies criteria (patterns) used to identify collections of rows in a table based on their relationships to one another
**行样式**
规定准则（样式）的正则表达式的形式，用于根据各行之间彼此的关系来标识表中行的汇集

row pattern input table
![](/home/attachment/202212/14/993931_167100313578193.png)
**行样式输入表**
![](/home/attachment/202212/15/993931_167108372012509.png)

row pattern match
![](/home/attachment/202212/14/993931_167100323430065.png)
**行样式匹配**
![](/home/attachment/202212/15/993931_167108376837867.png)

row pattern matching
process of identifying collections of rows in a table based on the patterns specified in row patterns
**匹配行样式**
基于行样式中规定的样式，标识表中行的汇集的过程

row pattern measure
named scalar expression defined with respect to the row pattern variables
**行样式标度**
定义的命名标量表达式，关于行样式变量

row pattern measure column
exported column of the row pattern output table, the value for which is specified by a row pattern measure
**行样式标度列**
行样式输出表的导出列，由行样式标度规定其值

row pattern measure function
window function whose value is specified by a row pattern measure
**行样式标度函数**
由行样式标度规定其值的窗口函数

row pattern output table
![](/home/attachment/202212/14/993931_167100337952494.png)
**行样式输出表**
![](/home/attachment/202212/15/993931_167108381674983.png)

row pattern partition
maximal collection of rows of the row pattern input table in which all rows have non-distinct values for a set of one or more columns, called the row pattern partitioning columns; or a window partition in a window whose descriptor has window row pattern recognition
**行样式分区**
行样式输入表的最大行 汇集，对于一个或多个列的集合，其中所有行都有非相异的值，称为该行样式分区若干列；或窗口中的窗口分区，其描述符具有窗口行样式识别

数据库标准

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

标准数据库技术词汇之ISO/IEC 9075-2（7）

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料