Slide/Important SQL Standards

Links

• recursive query
• XML
• XQuery
• TRUNCATE
• FETCH
• PERIOD FOR
• INSTEAD OF
• JSON
• row pattern matching
• Trigger
• ISO Standard
• SQL1
• SQL2
• SQL-92
• SQL99
• SQL2003
• SQL2006
• SQL2008
• SQL2011
• SQL2016
• SQL2019
• ANSI
• multidimensional array
• multidimensional data

• Petkovic2022
• Misev2017

Links hierher

Meta

Text

[edit]

Slide
edit
qkey	SQL-4
pkey	SQL
basename	4-RelationaleDatenbankspracheSQL.pptx
page	4
name	Important_SQL_Standards
title	Wichtige SQL Standards
keywords	recursive query, XML, XQuery, TRUNCATE, FETCH, PERIOD FOR, INSTEAD OF, JSON, row pattern matching, Trigger, ISO Standard, SQL1, SQL2, SQL-92, SQL99, SQL2003, SQL2006, SQL2008, SQL2011, SQL2016, SQL2019, ANSI, multidimensional array, multidimensional data
links
literature	Petkovic2022, Misev2017
learningGoal	→[[]]

[edit]

Wichtige SQL Standards
1986: SQL1 (ANSI Standard)•1992: SQL2 •oder• SQL-92 (ISO Standard)  (•wichtigster• Standard!)•1999: SQL3 •oder• SQL:1999: Trigger, •rekursive• •Abfragen•, OO•2003: SQL:2003: Window functions, Sequences•2006: SQL/XML:2006: XML, XQuery•2008: SQL:2008 •bzw•. ISO/IEC 9075:2008: INSTEAD OF-Trigger, TRUNCATE-Statement und FETCH •Klausel•.•2011: SQL:2011 •bzw•. ISO/IEC 9075:2011: „•Zeitbezogene• •Daten•“ (PERIOD FOR)•2016: SQL:2016 •bzw•. ISO/IEC 9075:2016: JSON und „row pattern matching”•2019: SQL/MDA:2019. •Datentyp• „•mehrdimensionales• Feld“