• Source: SQL: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. 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. 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



Structured Query Language




References






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

Kata Kunci Pencarian:

• Daftar kata yang dilindungi di SQL
• PostgreSQL
• Pangkalan data
• Microsoft Access
• Bahasa pemrograman tujuan umum
• Moodle
• WordPress
• Windows Server 2016
• X (media sosial)
• Basis data relasional
• SQL:2016
• SQL
• History of Microsoft SQL Server
• SQL-92
• SQL:2011
• SQL injection
• Null (SQL)
• Trino (SQL query engine)
• HSQLDB
• Microsoft SQL Server