If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7. Email:[email protected]
PDF Catalog
PDF Pages
PDF Title
1
30430207-NC.pdf
3
ISO_IEC DIS 9075-2 ed.6 – id.76584 Enquiry PDF (en).pdf
5
Contents
20
Tables
21
Figures
22
Foreword
24
Introduction
27
1 Scope
28
2 Normative references
30
3 Terms and definitions 3.1 Definitions taken from ISO/IEC 10646 3.2 Definitions taken from ISO/IEC 14651 3.3 Definitions taken from The Unicode® Standard
31
3.4 Definitions taken from ISO 8601-1:2019
32
3.5 Definitions taken from ISO/IEC 9075-1
34
3.6 Definitions provided in this document
42
4 Concepts 4.1 Notations and conventions 4.1.1 Notations 4.1.2 Use of terms
43
4.2 Data types 4.2.1 General introduction to data types
44
4.2.2 Naming of predefined types
45
4.2.3 Host language data types 4.2.4 Data type terminology
47
4.2.5 Properties of distinct
48
4.3 Character strings 4.3.1 Introduction to character strings 4.3.2 Comparison of character strings
49
4.3.3 Operations involving character strings 4.3.3.1 Regular expression syntaxes 4.3.3.2 Operators that operate on character strings and return character strings
52
4.3.3.3 Other operators involving character strings
53
4.3.3.4 Operations involving large object character strings
54
4.3.4 Character repertoires
55
4.3.5 Character encoding forms 4.3.6 Collations
56
4.3.7 Character sets
58
4.3.8 Universal character sets 4.4 Binary strings 4.4.1 Introduction to binary strings 4.4.2 Binary string comparison 4.4.3 Operations involving binary strings 4.4.3.1 Operators that operate on binary strings and return binary strings
59
4.4.3.2 Other operators involving binary strings 4.5 Numbers 4.5.1 Introduction to numbers
60
4.5.2 Characteristics of numbers
61
4.5.3 Operations involving numbers
62
4.6 Boolean types 4.6.1 Introduction to Boolean types
63
4.6.2 Comparison and assignment of Booleans 4.6.3 Operations involving Booleans 4.6.3.1 Operations on Booleans that return Booleans 4.6.3.2 Other operators involving Booleans 4.7 Datetimes and intervals 4.7.1 Introduction to datetimes and intervals
64
4.7.2 Datetimes
66
4.7.3 Intervals
68
4.7.4 Operations involving datetimes and intervals 4.8 JSON types 4.8.1 Introduction to JSON types
4.12.2 Arrays 4.12.3 Multisets 4.12.4 Collection comparison and assignment
80
4.12.5 Operations involving arrays 4.12.5.1 Operators that operate on array values and return array elements 4.12.5.2 Operators that operate on array values and return array values 4.12.5.3 Operators that operate on array values and return numbers 4.12.6 Operations involving multisets 4.12.6.1 Operators that operate on multisets and return multiset elements 4.12.6.2 Operators that operate on multisets and return multisets
81
4.12.6.3 Operators that operate on multiset values and return numbers 4.13 Data conversions
82
4.14 Domains 4.15 Columns, fields, and attributes
84
4.16 Periods 4.16.1 Introduction to periods
85
4.16.2 Operations involving periods 4.17 Tables 4.17.1 Introduction to tables 4.17.2 Base tables 4.17.2.1 Introduction to base tables
4.26 Functional dependencies 4.26.1 Overview of functional dependency rules and notations 4.26.2 General rules and definitions
122
4.26.3 Known functional dependencies in a base table
123
4.26.4 Known functional dependencies in a viewed table 4.26.5 Known functional dependencies in a transition table 4.26.6 Known functional dependencies in
4.26.7 Known functional dependencies in a
125
4.26.8 Known functional dependencies in a
126
4.26.9 Known functional dependencies in a
4.26.10 Known functional dependencies in a
4.26.11 Known functional dependencies in the result of a 4.26.12 Known functional dependencies in the result of a
127
4.26.13 Known functional dependencies in the result of a 4.26.14 Known functional dependencies in the result of a 4.26.15 Known functional dependencies in a
128
4.26.16 Known functional dependencies in a 4.27 Candidate keys
129
4.28 SQL-schemas
130
4.29 Sequence generators 4.29.1 General description of sequence generators
4.43 SQL-transactions 4.43.1 General description of SQL-transactions 4.43.2 Savepoints
178
4.43.3 Properties of SQL-transactions 4.43.4 Isolation levels of SQL-transactions
180
4.43.5 Implicit rollbacks 4.43.6 Effects of SQL-statements in an SQL-transaction 4.43.7 Encompassing transactions 4.43.7.1 Encompassing transaction belonging to an external agent
181
4.43.7.2 Encompassing transaction belonging to the SQL-agent 4.44 SQL-connections
182
4.45 SQL-sessions 4.45.1 General description of SQL-sessions
