ANSI INCITS 135 : 1992
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
View Superseded by
INFORMATION SYSTEMS - DATABASE LANGUAGE - SQL
Hardcopy , PDF
23-07-2013
INCITS/ISO/IEC 9075-1 : 2012
INCITS/ISO/IEC 9075-2 : 2012
INCITS/ISO/IEC 9075-5 : 1999
English
01-01-1998
Important note : All end users must be registered with an Account prior to user licenses being assigned.
Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
3.1 Definitions
3.2 Notation
3.3 Conventions
3.4 Object identifier for Database Language SQL
4 Concepts
4.1 Data types
4.2 Character strings
4.3 Bit strings
4.4 Numbers
4.5 Datetimes and intervals
4.6 Type conversions and mixing of data types
4.7 Domains
4.8 Columns
4.9 Tables
4.10 Integrity constraints
4.11 SQL-schemas
4.12 Catalogs
4.13 Clusters of catalogs
4.14 SQL-data
4.15 SQL-environment
4.16 Modules
4.17 Procedures
4.18 Parameters
4.19 Diagnostics area
4.20 Standard programming languages
4.21 Cursors
4.22 SQL-statements
4.23 Embedded syntax
4.24 SQL dynamic statements
4.25 Direct invocation of SQL
4.26 Privileges
4.27 SQL-agents
4.28 SQL-transactions
4.29 SQL-connections
4.30 SQL-sessions
4.31 Client-server operation
4.32 Information Schema
4.33 Leveling
4.34 SQL Flagger
5 Lexical elements
5.1
5.2
5.3
5.4 Names and identifiers
6 Scalar expressions
6.1
6.2
6.3
6.4
6.5
6.6
6.7
6.8
6.9
6.10
6.11
6.12
6.13
6.14
6.15
7 Query expressions
7.1
7.2
7.3
7.4
7.5
7.6
7.7
7.8
7.9
7.10
7.11
8 Predicates
8.1
8.2
8.3
8.4
8.5
8.6
8.7
8.8
8.9
8.10
8.11
8.12
9 Data assignment rules
9.1 Retrieval assignment
9.2 Store assignment
9.3 Set operation result data types
10 Additional common elements
10.1
10.2
10.3
10.4
10.5
10.6
11 Schema definition and manipulation
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
12 Module
12.1
12.2
12.3
12.4 Call to a
12.5
13 Data manipulation
13.1
13.2
13.3
13.4
13.5