{"id":636291,"date":"2024-11-06T00:56:32","date_gmt":"2024-11-06T00:56:32","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/iso-iec-9075-22016\/"},"modified":"2024-11-06T00:56:32","modified_gmt":"2024-11-06T00:56:32","slug":"iso-iec-9075-22016","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/iso\/iso-iec-9075-22016\/","title":{"rendered":"ISO\/IEC 9075-2:2016"},"content":{"rendered":"

ISO\/IEC 9075-2:2016 de?nes the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.<\/p>\n

ISO\/IEC 9075-2:2016 speci?es the syntax and semantics of a database language:<\/p>\n

– For specifying and modifying the structure and the integrity constraints of SQL-data.<\/p>\n

– For declaring and invoking operations on SQL-data and cursors.<\/p>\n

– For declaring database language procedures.<\/p>\n

– For embedding SQL-statements in a compilation unit that is otherwise written in a particular programming language (host language).<\/p>\n

– For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to exe-cuting the SQL-statement.<\/p>\n

– For direct invocation of SQL-statements.<\/p>\n

– To support dynamic preparation and execution of SQL-statements.<\/p>\n

ISO\/IEC 9075-2:2016 provides a vehicle for portability of data de?nitions and compilation units between SQL-implementations.<\/p>\n

ISO\/IEC 9075-2:2016 provides a vehicle for interconnection of SQL-implementations.<\/p>\n

Implementations of this ISO\/IEC 9075-2:2016 can exist in environments that also support application program-ming 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.<\/p>\n","protected":false},"excerpt":{"rendered":"

Information technology \u2014 Database languages \u2014 SQL \u2014 Part 2: Foundation (SQL\/Foundation)<\/b><\/p>\n\n\n\n\n
Published By<\/td>\nPublication Date<\/td>\nNumber of Pages<\/td>\n<\/tr>\n
ISO<\/b><\/a><\/td>\n2016-12<\/td>\n1732<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":636306,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[664,2634],"product_tag":[],"class_list":{"0":"post-636291","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-35-060","7":"product_cat-iso","9":"first","10":"instock","11":"sold-individually","12":"shipping-taxable","13":"purchasable","14":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/636291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/636306"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=636291"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=636291"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=636291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}