SQL:2016
In today's world, SQL:2016 has become a topic of great importance and interest to a wide range of people. SQL:2016 frequently sparks debate and controversy, generating widespread interest in its understanding and analysis. Throughout history, SQL:2016 has played a fundamental role in society, influencing various aspects of modern life. In this article, we will explore in depth the different facets of SQL:2016, analyzing its impact today and its relevance for the future.
| SQL language revisions |
|---|
SQL:2016 or ISO/IEC 9075:2016 (under the general title "Information technology – Database languages – SQL") is the eighth revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in December 2016.[1] The standard consists of 9 parts which are described in some detail in SQL. The next version is SQL:2023.
New features
SQL:2016 introduced 44 new optional features.[2] 22 of them belong to the JSON functionality, ten more are related to polymorphic table functions. The additions to the standard include:
- JSON: Functions to create JSON documents, to access parts of JSON documents and to check whether a string contains valid JSON data
- Row Pattern Recognition: Matching a sequence of rows against a regular expression pattern
- Date and time formatting and parsing
- LISTAGG: A function to transform values from a group of rows into a delimited string
- Polymorphic table functions: table functions without predefined return type
- New data type DECFLOAT
See also
References
- ^ "ISO/IEC 9075, 13249, and others". Retrieved 2017-03-15.
- ^ "What's New in SQL:2016". Retrieved 2017-06-16.
External links
- "SQL:2016", Catalogue (webshop), ISO.
- ISO/IEC TR 19075-5:2016: Row Pattern Recognition in SQL
- ISO/IEC TR 19075-6:2017: SQL support for JavaScript Object Notation (JSON)
- ISO/IEC TR 19075-7:2017: Polymorphic table functions in SQL
 | This computing article is a stub. You can help Wikipedia by expanding it. |