Customer Service:
Mon - Fri: 8:30 am - 6 pm EST

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:2016 (2017)

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

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


INCITS/ISO/IEC 9075-2:2016 (2017)

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:2016 (2018)

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:2016 (2017)

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 TR 19075-7:2017

Information technology - Database languages - SQL Technical Reports - Part 7: Polymorphic table functions in SQL

ISO/IEC TR 19075-7:2017 describes the definition and use of polymorphic table functions in SQL.

ISO/IEC TR 19075-7:2017 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:2016 (2017)

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:2016 (2017)

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 Java? programming language (Java is a registered trademark of Sun Microsystems, Inc.). The embedding of SQL into Java is commonly known as "SQLJ". This part of ISO/IEC 9075 specifies the syntax and semantics of SQLJ, as well as mechanisms to ensure binary portability of resulting SQLJ applications. In addition, it specifies a number of Java packages and their contained classes (including methods).


INCITS/ISO/IEC 9075-11:2016 (2017)

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

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


INCITS/ISO/IEC 9075-13:2016 (2017)

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 Java? 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.)



ANSI Logo

As the voice of the U.S. standards and conformity assessment system, the American National Standards Institute (ANSI) empowers its members and constituents to strengthen the U.S. marketplace position in the global economy while helping to assure the safety and health of consumers and the protection of the environment.

CUSTOMER SERVICE
NEW YORK OFFICE
ANSI HEADQUARTERS