INCITS/ISO/IEC 9075-2 : 2012
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 TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 2: FOUNDATION (SQL/FOUNDATION)
Hardcopy , PDF
23-04-2024
English
01-01-2012
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
4 Concepts
5 Lexical elements
6 Scalar expressions
7 Query expressions
8 Predicates
9 Additional common rules
10 Additional common elements
11 Schema definition and manipulation
12 Access control
13 SQL-client modules
14 Data manipulation
15 Additional data manipulation rules
16 Control statements
17 Transaction management
18 Connection management
19 Session management
20 Dynamic SQL
21 Embedded SQL
22 Direct invocation of SQL
23 Diagnostics management
24 Status codes
25 Conformance
Annex A (informative) - SQL Conformance Summary
Annex B (informative) - Implementation-defined elements
Annex C (informative) - Implementation-dependent elements
Annex D (informative) - Deprecated features
Annex E (informative) - Incompatibilities with ISO/IEC 9075:2008
Annex F (informative) - SQL feature taxonomy
Annex G (informative) - Defect Reports not addressed in this
edition of ISO/IEC 9075
Bibliography
Index
Describes the data structures and basic operations on SQL-data. Presents functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.
| DevelopmentNote |
Partially supersedes ANSI INCITS 135. (02/2003)
|
| DocumentType |
Standard
|
| Pages |
1472
|
| PublisherName |
Information Technology Industry Council
|
| Status |
Superseded
|
| SupersededBy | |
| Supersedes |
| Standards | Relationship |
| ISO/IEC 9075-2:2016 | Identical |
| ISO/IEC 8859-1:1998 | Information technology 8-bit single-byte coded graphic character sets Part 1: Latin alphabet No. 1 |
| ISO/IEC 10646:2014 | Information technology Universal Coded Character Set (UCS) |
| ISO/IEC 6429:1992 | Information technology Control functions for coded character sets |
| ISO 7185:1990 | Information technology — Programming languages — Pascal |
| ISO/IEC 1989:2014 | Information technology — Programming languages, their environments and system software interfaces — Programming language COBOL |
| ISO/IEC 14651:2016 | Information technology International string ordering and comparison Method for comparing character strings and description of the common template tailorable ordering |
| ISO/IEC 11756:1999 | Information technology Programming languages M |
| ISO/IEC 9075-10:2016 | Information technology — Database languages — SQL — Part 10: Object language bindings (SQL/OLB) |
| ISO 8601:2004 | Data elements and interchange formats Information interchange Representation of dates and times |
| ISO/IEC 10206:1991 | Information technology Progamming languages Extended Pascal |
| ISO/IEC 9075-9:2016 | Information technology — Database languages — SQL — Part 9: Management of External Data (SQL/MED) |
| ISO/IEC 1539-1:2010 | Information technology Programming languages Fortran Part 1: Base language |
| ISO/IEC 9899:2011 | Information technology Programming languages C |
| ISO/IEC 646:1991 | Information technology ISO 7-bit coded character set for information interchange |
| ISO/IEC 9075-13:2016 | Information technology — Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT) |
| ISO/IEC 9075-3:2016 | Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI) |
| ISO/IEC/IEEE 9945:2009 | Information technology — Portable Operating System Interface (POSIX®) Base Specifications, Issue 7 |
| ISO 6160:1979 | Programming languages — PL/1 |
| ISO/IEC 8652:2012 | Information technology — Programming languages — Ada |
| ISO/IEC 9075-14:2016 | Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) |
| ISO/IEC 9075-11:2016 | Information technology — Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata) |
| ISO/IEC 9075-4:2016 | Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) |
| ISO/IEC 9579:2000 | Information technology Remote database access for SQL with security enhancement |
| ISO/IEC 9075-1:2016 | Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) |
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.