BS ISO/IEC 12227:1995

1. Scope
2. Normative references
3. Notations and Structures
3.1 Syntax Notation
3.2 Semantic Notation
3.3 Structure
3.4 Examples, Notes and Index Entries
4. Design Goals and Language Summary
4.1 Design Goals
4.2 Language Summary
4.2.1 Overview
4.2.2 Compilation Units
4.2.3 Modules
4.2.4 Procedures and Cursors
4.2.5 Domain and Base Domain Declarations
4.2.6 Other Declarations
4.2.7 Value Expressions and Typing
4.2.8 Standard Post Processing
4.2.9 Extensions
4.2.10 Default Values in Grammar
4.3 Entry Level SQL
5. Lexical Elements
5.1 Character Set
5.2 Lexical Elements, Separators, and Delimiters
5.3 Identifiers
5.4 Literals and Data Classes
5.5 Comments
5.6 Reserved Words
6. Common Elements
6.1 Compilation Units
6.2 Context Clause
6.3 Table Names and the From Clause
6.4 References
6.5 Assignment Contexts and Conformance of an Expression
     to a Domain
6.6 Standard Post Processing
6.7 Extensions
7. Data Description Language and Data Semantics
7.1 Definitional Modules
7.1.1 Base Domain Declarations
7.1.2 The SAME Standard Base Domains
7.1.3 Domain and Subdomain Declarations
7.1.4 Constant Declarations
7.1.5 Record Declarations
7.1.6 Enumeration Declarations
7.1.7 Exception Declarations
7.1.8 Status Map Declarations
7.2 Schema Modules
7.2.1 Table Definitions
7.2.2 View Definitions
7.3 Data Conversions
8. Abstract Module Description Language
8.1 Abstract Modules
8.2 Procedures
8.3 Statements
8.4 Cursor Declarations
8.5 Cursor Procedures
8.6 Input Parameter Lists
8.7 Select Parameter Lists
8.8 Value Lists and Column Lists
8.9 Into_Clause and Insert_From_Clause
8.10 Value Expressions
8.11 Search Conditions
8.12 Subqueries
8.13 Status Clauses
9. Conformance
9.1 Introduction
9.2 Claims of Conformance
9.2.1 Introduction
9.2.2 Conformance via mapping
9.2.3 Conformance via effects
9.2.4 Multiple claims of conformance
9.3 Extensions
Annex A. SAMeDL_Standard
Annex B. SAMeDL_System
Annex C. Standard Support Operations and Specifications
C.1 Standard Base Domain Operations
C.1.1 All Domains
C.1.2 Numeric Domains
C.1.3 Int and Smallint Domains
C.1.4 Character Domains
C.1.5 Enumeration Domains
C.1.6 Boolean Functions
C.1.7 Operations Available to the Application
C.2 Standard Support Package Specifications
C.2.1 SQL_Standard
C.2.2 SQL_Boolean_Pkg
C.2.3 SQL_Int_Pkg
C.2.4 SQL_Smallint_Pkg
C.2.5 SQL_Real_Pkg
C.2.6 SQL_Double_Precision_Pkg
C.2.7 SQL_Char_Pkg
C.2.8 SQL_Enumeration_Pkg
Annex D. Transform Chart
Annex E. Glossary
Annex F. References
Index

Specifies the syntax and semantics of a database programming language, the SQL Ada Module Description Language, SAMeDL. Does not define the Programming Language Ada nor the Database Language SQL.