2016

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.

## Contents

* 1 New features
* 2 See also
* 3 References
* 4 External links

## 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

| Wikibooks has a book on the topic of: Structured Query Language

|

* Structured Query Language

## References

1. ↑ "ISO/IEC 9075, 13249, and others". https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/d/0.
2. ↑ "What's New in SQL:2016". https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016.

## External links

* "SQL:2016" (webshop), Catalogue, ISO, https://www.iso.org/standard/63555.html .
* 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

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/SQL:2016. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=SQL:2016&oldid=212823"