SQL

Structured Query Language, or SQL, is an information technology language that can give access and the ability to change or manipulate databases. This category has standards relating to SQL for easier understanding and use.

 Back to Programming and Technology Languages Home

INCITS/ISO/IEC 9075-1:2023 (2023)

Information technology - Database languages SQL - Part 1: Framework (SQL/Framework)

Describes the conceptual framework used in other parts of the ISO/IEC 9075 series to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation. This document also defines terms and notation used in the other parts of the ISO/IEC 9075 series.

INCITS/ISO/IEC 9075-2:2023 (2023)

Information technology - Database languages SQL - Part 2: Foundation (SQL/Foundation)

Defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.

INCITS/ISO/IEC 9075-3:2023 (2023)

Information technology - Database languages SQL - Part 3: Call-Level Interface (SQL/CLI)

Defines the structures and procedures that can be used to execute statements of the database language SQL from within an application written in a programming language in such a way that procedures used are independent of the SQL statements to be executed.

INCITS/ISO/IEC 9075-4:2023 (2023)

Information technology - Database languages SQL - Part 4: Persistent stored modules (SQL/PSM)

Specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules. The database language for s and s includes: the specification of statements to direct the flow of control, the assignment of the result of expressions to variables and parameters. The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.

ISO/IEC 19075-7:2021

Information technology - Guidance for the use of database language SQL - Part 7: Polymorphic table functions

This document describes the definition and use of polymorphic table functions in SQL. The Report discusses the following features of the SQL Language: — The processing model of polymorphic table functions in the context of SQL. — The creation and maintenance of polymorphic table functions. — Issues related to methods of implementing polymorphic table functions. — How polymorphic table functions are invoked by application programs. — Issues concerning compilation, optimization, and execution of polymorphic table functions.

INCITS/ISO/IEC 9075-9:2023 (2023)

Information technology - Database languages SQL - Part 9: Management of External Data (SQL/MED)

Defines extensions to Database Language SQL to support management of external data through the use of foreign-data wrappers and datalink types.

INCITS/ISO/IEC 9075-10:2023 (2023)

Information technology - Database languages SQL - Part 10: Object language bindings (SQL/OLB)

Specifies embedded SQL for the programming languages: Ada, C, COBOL, Fortran, MUMPS, Pascal, and PL/I. ISO/IEC 9075-10:2016 defines similar features of Database language SQL that support embedding of SQL-statements into programs written in the JavaTM programming language (Java is a registered trademark of Sun Microsystems, Inc.). The embedding of SQL into Java is commonly known as "SQLJ".

INCITS/ISO/IEC 9075-11:2023 (2023)

Information technology - Database languages SQL - Part 11: Information and definition schemas (SQL/Schemata)

Specifies an Information Schema and a Definition Schema that describes the structure and integrity constraints of SQL-data, the security and authorization specifications relating to SQL-data, the features and subfeatures of the ISO/IEC 9075 series, and the support that each of these has in an SQL-implementation, the SQL-implementation information and sizing items of the ISO/IEC 9075 series and the values supported by an SQL-implementation.

INCITS/ISO/IEC 9075-13:2023 (2023)

Information technology - Database languages SQL - Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT)

Specifies the ability to invoke static methods written in the JavaTM programming language as SQL-invoked routines and to use classes defined in the Java programming language as SQL structured user-defined types. (Java is a registered trademark of Oracle Corporation and/or its affiliates.)

INCITS/ISO/IEC 9075-14:2023 (2023)

Information technology - Database languages SQL - Part 14: XML-Related Specifications (SQL/XML)

Defines ways in which Database Language SQL can be used in conjunction with XML.

Useful Links

CUSTOMER SERVICE

Our Contacts

ANSI HEADQUARTERS
1899 L Street, NW, 11th Floor
Washington, DC 20036

Tel: 202.293.8020
Fax: 202.293.9287

NEW YORK OFFICE
1180 6th Ave, 10th floor
New York, NY 10036

Tel: 212. 642.4900
Fax: 212.398.0023