Foreword Introduction 1 Scope 2 Normative references 3 Definitions, notations, and conventions 3.1 Definitions 3.2 Notation 3.3 Conventions 3.3.1 Use of terms 3.3.1.1 Other terms 3.3.2 Relationships to other parts of ISO/IEC 9075 3.3.2.1 Clause, Subclause, and Table relationships 3.4 Object identifier for Database Language SQL 4 Concepts 4.1 Catalogs 4.2 SQL-client modules 4.3 SQL-invoked routines 4.4 Locators 4.5 Cursors 4.6 SQL-statements 4.6.1 Classes of SQL-statements 4.6.2 SQL-statements classified by function 4.6.3 SQL-statements and transaction states 4.6.4 Embeddable SQL-statements 4.6.5 Preparable and immediately executable SQL-statements 4.6.6 Directly executable SQL-statements 4.7 Standard programming languages 4.8 Embedded syntax 4.9 SQL dynamic statements 4.10 Direct invocation of SQL 4.11 Privileges and roles 4.12 SQL-transactions 4.13 SQL-connections 4.14 SQL-sessions 4.15 Client-server operation 5 Lexical elements 5.1 and 5.2 5.3 Names and identifiers 6 Scalar expressions 6.1 and specification> 6.2 6.3 7 Query expressions 7.1
7.2 8 Additional common elements 8.1 9 Data assignment rules and routine determination 9.1 Retrieval assignment 9.2 Store assignment 9.3 Data types of results of aggregations 10 Schema definition and manipulation 10.1 10.2 10.3 10.4 10.5 11 SQL-client modules 11.1 11.2 Calls to an 11.3 12 Data manipulation 12.1