MADCAD.com - The Cloud-Based Reference Library

⨯To continue with accurate pricing,
please select your company type below:

Large goverment organizations

Large multi-national corporation (more than $5B annual revenue)

None of the above

Your company has a special pricing case for IEEE.
For pricing, please contact us by filling out the form.

Full name*
Email*
Phone
Your selection

⨯We need your input!

Are you a code official in a jurisdiction with less than 300,000 population?

Yes No

This item is only available for the code officials of jurisdictions less then 300K population.

If you do not meet the criteria item will be removed and you will be able to continue shopping other items.

⨯ We need your input!

Your company has a special pricing case for ASME.
Please make sure the information you provide below is accurate.

Company Industry
Number Of Employees
Revenue

Pricing for the ASME publications in the store is for a 1-4 employee company in Construction Industry with revenue under $500,000.
If correct company info does not match what is publicly available info we will suspend the access and contact you for correction.
Please call 1-800-798-9296 if you have any questions.
If your company has more than 5,000 employee or more than 500 mil revenue please email us at info@madcad.com to receive a special quote, use "ASME Quote" on the subject line.

Search book title

Search book content

Clear all filters Advanced Search Basic Search

Download File

eLibrary > 22/30430207 DC BS ISO/IEC 9075-2. Information technology. Database languages. SQL - Part 2. Foundation (SQL/Foundation) >

22/30430207 DC BS ISO/IEC 9075-2. Information technology. Database languages. SQL - Part 2. Foundation (SQL/Foundation), 2022

Expand All

TOC Search:

22/30430207 DC BS ISO/IEC 9075-2. Information technology. Database languages. SQL - Part 2. Foundation (SQL/Foundation), 2022

30430207-NC.pdf
ISO_IEC DIS 9075-2 ed.6 - id.76584 Enquiry PDF (en).pdf [Go to Page]
Contents
Tables
Figures
Foreword
Introduction
1 Scope
2 Normative references
3 Terms and definitions [Go to Page]
3.1 Definitions taken from ISO/IEC 10646
3.2 Definitions taken from ISO/IEC 14651
3.3 Definitions taken from The Unicode® Standard
3.4 Definitions taken from ISO 8601-1:2019
3.5 Definitions taken from ISO/IEC 9075-1
3.6 Definitions provided in this document
4 Concepts [Go to Page]
4.1 Notations and conventions [Go to Page]
4.1.1 Notations
4.1.2 Use of terms
4.2 Data types [Go to Page]
4.2.1 General introduction to data types
4.2.2 Naming of predefined types
4.2.3 Host language data types
4.2.4 Data type terminology
4.2.5 Properties of distinct
4.3 Character strings [Go to Page]
4.3.1 Introduction to character strings
4.3.2 Comparison of character strings
4.3.3 Operations involving character strings [Go to Page]
4.3.3.1 Regular expression syntaxes
4.3.3.2 Operators that operate on character strings and return character strings
4.3.3.3 Other operators involving character strings
4.3.3.4 Operations involving large object character strings
4.3.4 Character repertoires
4.3.5 Character encoding forms
4.3.6 Collations
4.3.7 Character sets
4.3.8 Universal character sets
4.4 Binary strings [Go to Page]
4.4.1 Introduction to binary strings
4.4.2 Binary string comparison
4.4.3 Operations involving binary strings [Go to Page]
4.4.3.1 Operators that operate on binary strings and return binary strings
4.4.3.2 Other operators involving binary strings
4.5 Numbers [Go to Page]
4.5.1 Introduction to numbers
4.5.2 Characteristics of numbers
4.5.3 Operations involving numbers
4.6 Boolean types [Go to Page]
4.6.1 Introduction to Boolean types
4.6.2 Comparison and assignment of Booleans
4.6.3 Operations involving Booleans [Go to Page]
4.6.3.1 Operations on Booleans that return Booleans
4.6.3.2 Other operators involving Booleans
4.7 Datetimes and intervals [Go to Page]
4.7.1 Introduction to datetimes and intervals
4.7.2 Datetimes
4.7.3 Intervals
4.7.4 Operations involving datetimes and intervals
4.8 JSON types [Go to Page]
4.8.1 Introduction to JSON types
4.8.2 Comparison and assignment of JSON values
4.8.3 Operations involving JSON values
4.9 User-defined types [Go to Page]
4.9.1 Introduction to user-defined types
4.9.2 Distinct types
4.9.3 Structured types [Go to Page]
4.9.3.1 Introduction to structured types
4.9.3.2 Observer functions and mutator functions
4.9.3.3 Constructors
4.9.3.4 Subtypes and supertypes
4.9.4 Methods
4.9.5 User-defined type comparison and assignment
4.9.6 Transforms for user-defined types
4.9.7 User-defined type descriptor
4.10 Row types
4.11 Reference types [Go to Page]
4.11.1 Introduction to reference types
4.11.2 Operations involving references
4.12 Collection types [Go to Page]
4.12.1 Introduction to collection types
4.12.2 Arrays
4.12.3 Multisets
4.12.4 Collection comparison and assignment
4.12.5 Operations involving arrays [Go to Page]
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 [Go to Page]
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
4.12.6.3 Operators that operate on multiset values and return numbers
4.13 Data conversions
4.14 Domains
4.15 Columns, fields, and attributes
4.16 Periods [Go to Page]
4.16.1 Introduction to periods
4.16.2 Operations involving periods
4.17 Tables [Go to Page]
4.17.1 Introduction to tables
4.17.2 Base tables [Go to Page]
4.17.2.1 Introduction to base tables
4.17.2.2 Regular persistent base tables
4.17.2.3 System-versioned tables
4.17.2.4 Temporary tables
4.17.3 Derived tables
4.17.4 Transient tables
4.17.5 Unique identification of tables
4.17.6 Table updatability
4.17.7 Table descriptors
4.17.8 Syntactic analysis of derived tables and cursors
4.17.9 Referenceable tables, subtables, and supertables
4.17.10 Operations involving tables
4.17.11 Range variables
4.17.12 Identity columns
4.17.13 Base columns and generated columns
4.17.14 Grouped tables
4.17.15 Windowed tables
4.18 Data analysis operations (involving tables) [Go to Page]
4.18.1 Introduction to data analysis operations
4.18.2 Group functions
4.18.3 Window functions
4.18.4 Aggregate functions
4.18.5 Row pattern measures
4.19 Row pattern matching [Go to Page]
4.19.1 Introduction to row pattern matching
4.19.2 Matching rows with a pattern
4.19.3 Row pattern matching illustrated
4.19.4 Row pattern partitioning
4.19.5 Row ordering
4.19.6 Row pattern measure columns
4.19.7 Number of rows per match
4.19.8 Skipping rows after matching
4.20 Row patterns
4.21 Unions of row pattern variables
4.22 Defining Boolean conditions
4.23 Scalar expressions in row pattern matching [Go to Page]
4.23.1 Introduction to scalars in row pattern matching
4.23.2 Running vs. final semantics
4.23.3 Row pattern navigation operations
4.23.4 Row pattern classifier function
4.23.5 Row pattern match number function
4.24 Determinism
4.25 Integrity constraints [Go to Page]
4.25.1 Overview of integrity constraints
4.25.2 Checking of constraints
4.25.3 Table constraints [Go to Page]
4.25.3.1 Introduction to table constraints
4.25.3.2 Unique constraints
4.25.3.3 Referential constraints
4.25.3.4 Table check constraints
4.25.4 Domain constraints
4.25.5 Assertions
4.26 Functional dependencies [Go to Page]
4.26.1 Overview of functional dependency rules and notations
4.26.2 General rules and definitions
4.26.3 Known functional dependencies in a base table
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
4.26.8 Known functional dependencies in a

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
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
4.26.16 Known functional dependencies in a
4.27 Candidate keys
4.28 SQL-schemas
4.29 Sequence generators [Go to Page]
4.29.1 General description of sequence generators
4.29.2 Operations involving sequence generators
4.30 SQL-client modules
4.31 Embedded syntax
4.32 Dynamic SQL concepts [Go to Page]
4.32.1 Introduction to dynamic SQL
4.32.2 Overview of dynamic SQL for constructed SQL-statements
4.32.3 Overview of dynamic SQL for polymorphic table functions
4.32.4 Dynamic SQL statements and descriptor areas
4.33 Direct invocation of SQL
4.34 Externally-invoked procedures
4.35 SQL-invoked routines [Go to Page]
4.35.1 Overview of SQL-invoked routines
4.35.2 Characteristics of SQL-invoked routines
4.35.3 Execution of conventional SQL-invoked routines
4.35.4 Invocation of polymorphic table functions
4.35.5 Routine descriptors
4.35.6 Result sets returned by SQL-invoked procedures
4.36 SQL-paths
4.37 Host parameters [Go to Page]
4.37.1 Overview of host parameters
4.37.2 Status parameters
4.37.3 Data parameters
4.37.4 Indicator parameters
4.37.5 Locators
4.38 Diagnostics area
4.39 Host languages
4.40 Cursors [Go to Page]
4.40.1 General description of cursors
4.40.2 Operations on and using cursors
4.41 SQL-statements [Go to Page]
4.41.1 Classes of SQL-statements
4.41.2 SQL-statements classified by function [Go to Page]
4.41.2.1 SQL-schema statements
4.41.2.2 SQL-data statements
4.41.2.3 SQL-data change statements
4.41.2.4 SQL-transaction statements
4.41.2.5 SQL-connection statements
4.41.2.6 SQL-control statements
4.41.2.7 SQL-session statements
4.41.2.8 SQL-diagnostics statements
4.41.2.9 SQL-dynamic statements
4.41.2.10 SQL embedded exception declaration
4.41.3 SQL-statements and SQL-data access indication
4.41.4 SQL-statements and transaction states
4.41.5 SQL-statement atomicity and statement execution contexts
4.41.6 Embeddable SQL-statements
4.41.7 Preparable and immediately executable SQL-statements
4.41.8 Directly executable SQL-statements
4.42 Basic security model [Go to Page]
4.42.1 Authorization identifiers [Go to Page]
4.42.1.1 Introduction to authorization identifiers
4.42.1.2 SQL-session authorization identifiers
4.42.1.3 SQL-client module authorization identifiers
4.42.1.4 SQL-schema authorization identifiers
4.42.2 Privileges
4.42.3 Roles
4.42.4 Security model definitions
4.43 SQL-transactions [Go to Page]
4.43.1 General description of SQL-transactions
4.43.2 Savepoints
4.43.3 Properties of SQL-transactions
4.43.4 Isolation levels of SQL-transactions
4.43.5 Implicit rollbacks
4.43.6 Effects of SQL-statements in an SQL-transaction
4.43.7 Encompassing transactions [Go to Page]
4.43.7.1 Encompassing transaction belonging to an external agent
4.43.7.2 Encompassing transaction belonging to the SQL-agent
4.44 SQL-connections
4.45 SQL-sessions [Go to Page]
4.45.1 General description of SQL-sessions
4.45.2 SQL-session identification
4.45.3 SQL-session properties
4.45.4 SQL-session context management
4.45.5 Execution contexts
4.45.6 Routine execution context
4.46 Triggers [Go to Page]
4.46.1 General description of triggers
4.46.2 Trigger execution
4.47 Client-server operation
4.48 JSON data handling in SQL [Go to Page]
4.48.1 Introduction
4.48.2 Implied JSON data model
4.48.3 SQL/JSON data model
4.48.4 SQL/JSON functions
4.48.5 Overview of SQL/JSON path language
5 Lexical elements [Go to Page]
5.1
5.2 and
5.3
5.4 Names and identifiers
6 Scalar expressions [Go to Page]
6.1
6.2
6.3
6.4 and
6.5
6.6
6.7
6.8
6.9
6.10
6.11
6.12
6.13
6.14
6.15
6.16
6.17
6.18
6.19
6.20
6.21
6.22
6.23
6.24
6.25
6.26
6.27
6.28
6.29
6.30
6.31
6.32
6.33
6.34
6.35
6.36
6.37
6.38
6.39
6.40
6.41
6.42
6.43
6.44
6.45
6.46
6.47
6.48
6.49
6.50
6.51
6.52
7 Query expressions [Go to Page]
7.1
7.2
7.3

7.7
7.8
7.9
7.10
7.11
7.12
7.13
7.14
7.15
7.16
7.17
7.18
7.19
8 Predicates [Go to Page]
8.1
8.2
8.3
8.4
8.5
8.6
8.7
8.8
8.9
8.10
8.11
8.12
8.13
8.14
8.15
8.16
8.17
8.18
8.19
8.20
8.21
8.22
8.23
9 Additional common rules [Go to Page]
9.1 Retrieval assignment
9.2 Store assignment
9.3 Passing a value from a host language to the SQL-server
9.4 Passing a value from the SQL-server to a host language
9.5 Result of data type combinations
9.6 Subject routine determination
9.7 Type precedence list determination
9.8 Host parameter mode determination
9.9 Type name determination
9.10 Determination of identical values
9.11 Equality operations
9.12 Grouping operations
9.13 Multiset element grouping operations
9.14 Ordering operations
9.15 Collation determination
9.16 Potential sources of non-determinism
9.17 Executing an
9.18 Invoking an SQL-invoked routine
9.19 Processing a method invocation
9.20 Transformation of query specifications
9.21 Execution of array-returning external functions
9.22 Execution of multiset-returning external functions
9.23 Compilation of an invocation of a polymorphic table function
9.24 Execution of an invocation of a polymorphic table function
9.25 Signatures of PTF component procedures
9.26 Invocation of a PTF component procedure
9.27 XQuery regular expression matching
9.28 XQuery regular expression replacement
9.29 Data type identity
9.30 Determination of a from-sql function
9.31 Determination of a from-sql function for an overriding method
9.32 Determination of a to-sql function
9.33 Determination of a to-sql function for an overriding method
9.34 Generation of the next value of a sequence generator
9.35 Creation of a sequence generator
9.36 Altering a sequence generator
9.37 Generation of the hierarchical of a view
9.38 Determination of view privileges
9.39 Determination of view component privileges
9.40 Row pattern recognition in a sequence of rows
9.41 Parsing JSON text
9.42 Serializing an SQL/JSON item
9.43 Converting an SQL/JSON sequence to an SQL/JSON item
9.44 SQL/JSON path language: lexical elements
9.45 SQL/JSON path language: syntax and semantics
9.46 Processing
9.47 Casting an SQL/JSON sequence to an SQL type
9.48 Serializing an SQL/JSON sequence to an SQL string type
9.49 Converting a datetime to a formatted character string
9.50 Converting a formatted character string to a datetime
9.51 Datetime templates
10 Additional common elements [Go to Page]
10.1
10.2
10.3
10.4
10.5
10.6
10.7
10.8 and
10.9
10.10
10.11
10.12
10.13
10.14
11 Schema definition and manipulation [Go to Page]
11.1
11.2
11.3

11.4
11.5
11.6

11.7
11.8
11.9
11.10
11.11
11.12
11.13
11.14
11.15
11.16
11.17
11.18
11.19
11.20
11.21
11.22
11.23
11.24
11.25
11.26
11.27
11.28
11.29
11.30
11.31
11.32
11.33
11.34
11.35
11.36
11.37
11.38
11.39
11.40
11.41
11.42
11.43
11.44
11.45
11.46
11.47
11.48
11.49
11.50
11.51
11.52
11.53
11.54
11.55
11.56
11.57
11.58
11.59
11.60
11.61
11.62
11.63
11.64
11.65
11.66
11.67
11.68
11.69
11.70
11.71
11.72
11.73
11.74
12 Access control [Go to Page]
12.1
12.2
12.3
12.4
12.5
12.6
12.7
12.8 Grantor determination
13 SQL-client modules [Go to Page]
13.1
13.2
13.3
13.4
13.5 Data type correspondences
14 Data manipulation [Go to Page]
14.1
14.2
14.3
14.4
14.5
14.6
14.7
20.12
20.13
20.14
20.15
20.16
20.17
20.18
20.19
20.20
20.21
20.22
20.23
20.24
20.25
20.26
20.27
20.28
21 Embedded SQL [Go to Page]
21.1
21.2
21.3
21.4
21.5
21.6
21.7
21.8
21.9
22 Direct invocation of SQL [Go to Page]
22.1
22.2
23 Diagnostics management [Go to Page]
23.1
23.2 Pushing and popping the diagnostics area stack
24 Status codes [Go to Page]
24.1 SQLSTATE
24.2 Remote Database Access SQLSTATE Subclasses
25 Conformance [Go to Page]
25.1 Claims of conformance to SQL/Foundation
25.2 Additional conformance requirements for SQL/Foundation
25.3 Implied feature relationships of SQL/Foundation
25.4 Syntactic transformations applied before Conformance Rules in SQL/Foundation
A SQL Conformance Summary
B Implementation-defined elements
C Implementation-dependent elements
D SQL optional feature taxonomy
E Deprecated features
F Incompatibilities with ISO/IEC 9075:2016
G Defect Reports not addressed in this edition of this document
H SQL mandatory feature taxonomy
Bibliography
Index [Go to Page]

About Us / Careers / support@madcad.com / 1.800.798.9296

Email *
Password *
Confirm *
First Name *
Last Name *
Title
Company Name *
Company Size *
Industry *
Address *
Address 2
City *
State *	Zip *
Country *
Phone *
How did you hear about MADCAD.com? *

Report To Us

Contact us for a custom quote

⨯To continue with accurate pricing,
please select your company type below:

⨯We need your input!

⨯ We need your input!

⨯We need your input!

⨯We need your input!

Cart Warning

22/30430207 DC BS ISO/IEC 9075-2. Information technology. Database languages. SQL - Part 2. Foundation (SQL/Foundation), 2022

MADCAD.com Free Trial

Username:
Password:

Report To Us

Contact us for a custom quote

⨯To continue with accurate pricing, please select your company type below:

⨯We need your input!

⨯ We need your input!

⨯We need your input!

⨯We need your input!

Cart Warning

22/30430207 DC BS ISO/IEC 9075-2. Information technology. Database languages. SQL - Part 2. Foundation (SQL/Foundation), 2022

MADCAD.com Free Trial

⨯To continue with accurate pricing,
please select your company type below: