dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2 [2021/04/17 00:50] nick created |
dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2 [2021/08/17 15:22] (current) murphy |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== ISO/IEC 9075-2:2016 Database languages — SQL — Part 2: Foundation (SQL/Foundation) ===== | + | ===== ISO/IEC 9075-02:2016 Database languages — SQL — Part 2: Foundation (SQL/Foundation) ===== |
| - | [[dido:public:ra:xapend:xapend.b_stds:tech:iso| return to the ISO Standards ]] | + | [[dido:public:ra:xapend:xapend.b_stds:tech:iso:start| return to the ISO Standards ]] |
| <table> | <table> | ||
| Line 9: | Line 9: | ||
| | Document Number | ISO/IEC 9075-2:2016| | | Document Number | ISO/IEC 9075-2:2016| | ||
| | Release Date | 2016-12 | | | Release Date | 2016-12 | | ||
| - | | Reference | [[URI]] | | + | | Reference | [[https://www.iso.org/obp/ui/#iso:std:iso-iec:9075:-2:ed-5:v1:en]] | |
| </table> | </table> | ||
| Line 15: | Line 15: | ||
| ==== Scope ==== | ==== Scope ==== | ||
| - | //This part of ISO/IEC 9075 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.// | + | //This part of ISO/IEC 9075 defines the [[dido:public:ra:xapend:xapend.a_glossary:d:datastructure|data structures]] and basic operations on [[dido:public:ra:xapend:xapend.a_glossary:s:sql|SQL]]-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.// |
| - | //This part of ISO/IEC 9075 specifies the syntax and semantics of a database language:// | + | //This part of ISO/IEC 9075 specifies the [[dido:public:ra:xapend:xapend.a_glossary:s:syntax|syntax]] and semantics of a database language:// |
| * //For specifying and modifying the structure and the integrity constraints of SQL-data.// | * //For specifying and modifying the structure and the integrity constraints of SQL-data.// | ||
| * //For declaring and invoking operations on SQL-data and cursors.// | * //For declaring and invoking operations on SQL-data and cursors.// | ||
| * //For declaring database language procedures.// | * //For declaring database language procedures.// | ||
| - | * //For embedding SQL-statements in a compilation unit that is otherwise written in a particular programming language (host language).// | + | * //For embedding SQL-statements in a compilation unit that is otherwise written in a particular [[dido:public:ra:xapend:xapend.a_glossary:p:programlang|programming language]] (host language).// |
| * //For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement.// | * //For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement.// | ||
| * //For direct invocation of SQL-statements.// | * //For direct invocation of SQL-statements.// | ||
| * //To support dynamic preparation and execution of SQL-statements.// | * //To support dynamic preparation and execution of SQL-statements.// | ||
| - | //This part of ISO/IEC 9075 provides a vehicle for portability of data definitions and compilation units between SQL-implementations.// | + | //This part of ISO/IEC 9075 provides a vehicle for [[dido:public:ra:xapend:xapend.a_glossary:p:portability|portability]] of data definitions and compilation units between SQL-implementations.// |
| //This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations.// | //This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations.// | ||
| - | //Implementations of this part of ISO/IEC 9075 can exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and performance optimization.// | + | //Implementations of this part of ISO/IEC 9075 can exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and [[dido:public:ra:xapend:xapend.a_glossary:p:performance|performance]] optimization.// |
| + | |||
| + | ==== See Also ==== | ||
| + | |||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part1]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblangsql_part3]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part4]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part9]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part10]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part11]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part13]] | ||
| + | * [[dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part14]] | ||
| + | |||
| + | |||
| + | /**=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | ||
| + | /* To add a discussion page to this page, comment out the line that says | ||
| + | ~~DISCUSSION:off~~ | ||
| + | */ | ||
| + | ~~DISCUSSION:on|Outstanding Issues~~ | ||
| + | ~~DISCUSSION:off~~ | ||
dido/public/ra/xapend/xapend.b_stds/tech/iso/dblang_sql_part2.1618635024.txt.gz · Last modified: 2021/04/17 00:50 by nick
