
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
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
Committee |
X3H2
|
DevelopmentNote |
Supersedes ANSI INCITS 168. (05/2002)
|
DocumentType |
Standard
|
Pages |
626
|
PublisherName |
Information Technology Industry Council
|
Status |
Superseded
|
SupersededBy | |
Supersedes |
CSA ISO/IEC 13818-6 : 2002 : R2010 | INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC |
CSA ISO/IEC 13818-6 : 2002 | INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC |
ANSI INCITS 168 : 1989 | INFORMATION SYSTEMS - DATABASE LANGUAGE - EMBEDDED SQL |
ANSI INCITS 135.10 : 1998 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 10: OBJECT LANGUAGE BINDINGS (SQL/OLB) |
ANSI INCITS 320 : 1998 | INFORMATION TECHNOLOGY - SPATIAL DATA TRANSFER STANDARD (SDTS) |
AIIM MS60 : 0 | ELECTRONIC FOLDER INTERCHANGE DATASTREAM |
ANSI INCITS 331.1 : 1999 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQLJ - PART 1: SQL ROUTINES USING THE JAVA PROGRAMMING LANGUAGE |
CSA ISO/IEC 13818-6 : 2002 : INC : AMD 3 : 2003 : R2015 | INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC |
ISO/IEC 13818-6:1998 | Information technology — Generic coding of moving pictures and associated audio information — Part 6: Extensions for DSM-CC |
ANSI INCITS 9 : 78(R1989) | PROGRAMMING LANGUAGE FORTRAN |
ISO/IEC 10646:2014 | Information technology Universal Coded Character Set (UCS) |
ANSI INCITS 53 : 1976 | PROGRAMMING LANGUAGE PL/I |
ISO/IEC 2022:1994 | Information technology Character code structure and extension techniques |
ISO/IEC 8824:1990 | Information technology — Open Systems Interconnection — Specification of Abstract Syntax Notation One (ASN.1) |
MIL-STD-1815 Revision A:1983 | |
IEEE 770X3.160-1989 | IEEE/ANSI Standard for the Programming Language Extended Pascal |
ISO 8601:2004 | Data elements and interchange formats Information interchange Representation of dates and times |
ANSI INCITS 159 : 1989 | "C" PROGRAMMING LANGUAGE |
ISO/IEC 9579-2:1998 | Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization |
ANSI INCITS 23 : 1985 | PROGRAMMING LANGUAGE - COBOL |
ANSI INCITS 198 : 1992 | PROGRAMMING LANGUAGE - FORTRAN - EXTENDED |
ISO/IEC 646:1991 | Information technology ISO 7-bit coded character set for information interchange |
MDC X11.1 : 1995 | INFORMATION SYSTEMS - PROGRAMMING LANGUAGES - MUMPS |
Access your standards online with a subscription
Features
-
Simple online access to standards, technical information and regulations.
-
Critical updates of standards and customisable alerts and notifications.
-
Multi-user online standards collection: secure, flexible and cost effective.
Logging out.