开发者

Does any SQL standard include a REF CURSOR or TABLE type definition?

I always find it hard to read the rather abstract SQL standard specification, for instance this document here:

http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

I'm wondering, is any of the major RDBMS's supported concepts of REF CURSOR's (Oracle, Postgres, SQL Server, ...), or TABLE types (which can be used as nested tables, e.g. in Oracle), or any related concept standardised in some way?

For instance, HSQLDB, a very standards-compliant d开发者_如何学编程atabase (since version 2.0) supports the UNNEST function to unnest ARRAY types into tables. This concept of unnesting can be considered part of the non-first normal form in relational modelling, which seems to be a common concept. That's why I thought it might be worth standardising...

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜