Quelltext der Seite ISO/IEC TR 19075-6:2017

{{Quelle:Technischer Bericht
| key          =  ISO 19075-6 (2017)
| authors      = 
| title        = ISO/IEC TR 19075-6 
| subtitle     = Information technology — Database languages — SQL Technical Reports — Part 6: SQL support for JavaScript Object Notation (JSON)
| organization = Internationale Organisation für Normung (ISO)
| school       = 
| department   =
| address      =
| year         = 2017
| month        = 
| day          =
| url          = https://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip
| language     =
| quality      = 4
| annotations  =
}}
==Aus dem Inhalt==

<pre>
5.3 Query functions . . . . . . . . . . . . . . . . . . 24
5.3.1 JSON_EXISTS . . . . . . . . . . . . . . . . . . . 24
5.3.2 JSON_VALUE. . . . . . . . . . . . . . . . . . . . 27
5.3.3 JSON_QUERY. . . . . . . . . . . . . . . . . . . . 32
5.3.4 JSON_TABLE. . . . . . . . . . . . . . . . . . . . 35
5.3.4.1 COLUMNS clause that is not nested . . . . . . . 36
5.3.4.2 Nested COLUMNS clause . . . . . . . . . . . . . 39
5.3.4.3 PLAN clause . . . . . . . . . . . . . . . . . . 40
5.3.5 Conformance features for query operators. . . . . 44
5.4 Constructor functions and IS JSON predicate . . . . 46
5.4.1 JSON_OBJECT . . . . . . . . . . . . . . . . . . . 47
5.4.2 JSON_OBJECTAGG. . . . . . . . . . . . . . . . . . 48
5.4.3 JSON_ARRAY. . . . . . . . . . . . . . . . . . . . 50
5.4.4 JSON_ARRAYAGG . . . . . . . . . . . . . . . . . . 50
5.4.5 IS JSON predicate . . . . . . . . . . . . . . . . 52
5.4.6 Handling of JSON nulls and SQL nulls. . . . . . . 53
</pre>
[[Kategorie:Quelle:Datenmanagement]]